{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Questions for producers (2)","Directions","Questions for Producers","Fencing","Enterprise budget","Breeding Herd","Marketing","Feed, Hay, Supplements","Animal Health","Pasture","Labor","Equipment and Facilities","Fuel and Utilities","Operating Loan and Interest","Taxes","Insurance","Assumptions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Questions for producers (2)","index":0,"n_rows":430,"n_cols":8,"rows_kept":430,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["There are 13 broad categories of revenue and expenses we would like to understand about your operation: "]
["Breeding herd"]
["Market animals sold "]
["Feed and hay"]
["Animal health and medical "]
["Pasture/Land/Fertilizer"]
["Fencing "]
["Equipment "]
["Fuel"]
["Labor "]
["Utilities "]
["Operating Loans"]
["Insurance"]
["Taxes"]
[null,null,null,null,null,"Interview 1 responses"]
[null,"woukd usually sell now, but is going to carry",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Breeding herd","Oct 1 2017- Sept 30 2018","unit",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Number of breeding cows",50,"head"," (includes heifers, potenitally already bred)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Useful life of cow ",9,"years",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Cow salvage value (after useful life how much could you sell the cow for)",1150,null,"inventory value of herd and charge an interest rate to it"]
["What percent of your cows have a calf that is sold or used a replacement each year?",0.9,null,"maybe 85% last year, been 94% before ",{"$f":"SUM(B62,B67,B35)/B21","v":0.88}]
["What percent of your cows do you replace each year?",0.08,"percent",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["How many cows die per year on your farm",0,"head",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Do you raise or purchase replacement heifers?","raised, bought some cows last year and kept half, bred cows, paid $900 head,22 and sold half immediately, maybe have grown by 5 or 10",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,"note from jenny: 9 years, 15% replacement? "]
["Number of purchased replacement heifers",0,"head"]
["Age of replacement heifers (years) at purchase",null,"months",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Weight of replacement heifers (lbs.) at purchase",null,"lbs",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Price per cwt of replacement heifers",140,"per cwt",{"$f":"B33*(B32/100)","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Number of raised replacement heifers",4,"head"]
["Age of replacement heifers in years",null,"months"]
["If sold, anticipated weight at sale",700,"lbs"]
["Expected price per cwt of replacement heifers ",140,"per cwt"]
[]
["Check on replacements and culls",{"$f":"SUM(B35,B30)=SUM(B72,B26)","v":false},"True if same, false if different"]
[]
["# of bulls on your operation",{"$f":"F42","v":{"$error":"#REF!"}},"head",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["On average, how much do you pay for a bull  ($/head)",2000,"per head",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Useful life of bull (in years)",5,"years",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Salvage value for the bull, meaning when you are ready to sell the bull, what price do you expect to receive? ",{"$f":"0.9 *1800","v":1620},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
["Market animals sold ",null,null,null,null,"Interview 1 responses"]
["Calving season ",{"$f":"F50","v":{"$error":"#REF!"}},"idea is 90 days ",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["At what age are your calves weaned?","varies by year, some years don't pull them, will usually pull at 10 months, keep separate for 2 months and then put back together","months"]
["When do you wean your calves? All at once? What happens after weaning? ","all at once when you pull, have used weaner rings before. "]
["At what age are your bull calves castrated?","3 months or less, used all methods, lately band, sometime californina band (quicker) ","months"]
["At what age do you typically transport calves to market or off the ranch to another stage of production (backgrounding, stocker, feed lot)?","most sold at 700 lbs, bottom end will go to market, like one herd because easier, don't wean ewe lambs, stress, predator problems, will abort if heifer are too young","months"]
[]
["On average, how many calves/yearlings die per year?",2]
["Do you know the cause of death if an animal dies on your ranch?","blackleg, weather condition, wet and muddy "]
[]
["In interview 1 you stated your operation primarily sold animals though X method. Can you please confirm and expand? Do you market all your calves at the same time or different times? If different, how many at one time? ",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["How do you haul animal to mkt ","custom hauler, $100 to stockyard, 20 yearlings, two trips per year, might sell bottom end at 500lbs, total of 45",null,null,"Jenny wrote something about $1.20 "]
["# of feeder steers sold",22,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Average weight of feeder steer",600,"lbs","(sell about half around 500, might be 7 months to 9, 700 lbs",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Average age of feeder steers at sale","7 to 9","months",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Average price per cwt for feeder steer ",1.45,"per cwt","younger- $1.45, older 700 about $1.45 due to differences in quality"]
[null,null,null,null,"from Jenny, see calves 10 to 18 months"]
["# of feeder heifers sold",{"$f":"45-5-22","v":18},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Average weight of feeder heifer",600,"lbs",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Average age of feeder heifer at sale","7 to 9","months",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Average price per cwt for feeder heifer ",1.45,"per cwt",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,"Notes from Jenny, $1.2 to $1.40 "]
["# of cull cows sold",3.5,"3 or 4"]
["Average weight of cull cow",1100]
["Average price per cwt for cull cow ",{"$f":"Assumptions!B8","v":53.2},"pretty close, might be lower if don’t have weight, maybe .40 lb "]
[]
["If you sold these animals at an auction what was the commission percent? (might also ask about check off)",{"$f":"Assumptions!B11","v":0.02}]
[]
[]
["Do you quarantine new cattle brought onto your ranch?","for 30 days"]
[]
[]
["Purchased feed"]
["Grain 1 description","Range cubes",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["How much do you feed? Maybe on a per animal per day is easier ","50 lbs page"]
["Amount of grain purchased",null,"bag"]
["Cost per unit of grain",{"$f":"Assumptions!K37","v":0},"per bag"]
[]
["Grain 2 description"]
["Amount of grain purchased",null,"ton"]
["Cost per unit of grain",null,"per ton"]
[]
["HAY "]
["When is hay fed? ","jan, feb, march and part of april , other sperts throughout year for grass regrowth, about 3 rolls per day for 90 days, around 276"]
["Purchased Hay"]
["Alfalfa Hay description","Purchased Alfalfa Hay",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Number of units purchased",{"$f":"200*0.1","v":20},"square bales",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Cost per unit of alfalfa",4,"per bale",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Grass/Pasture Hay description","Purchased Pature Hay","5.5 ewe= 1 animal unit, cows weigh 1000, 1 animal unit, "]
["Number of units purchased",250000,"ton",null,"From Jenny: Buys hay, 200 rolls but note about using 300."]
["Cost per unit of Grass/Pasture",{"$f":"38*2","v":76},"per ton"]
[null,null,"250 bales per year for both, 180 ewes/5.5, 50 cattle, 1000 lb rolls, 5X5 a few square bales, 200 alfalfa square bales mostly for sheep, $33 per bale + $5 delivery, $4 per alfalfa, 90% "]
["Homegrown Hay","NONE","if feeding more than 90 days then they are carrying to omany livestock "]
["Alfalfa Hay description","Homegrown Alfalfa Hay"]
["Number of bales grown",null,"ton"]
["How much could you sell that hay for?",{"$f":"B97","v":4},"per ton"]
[]
["Grass/Pasture Hay description","Homegrown Pature Hay"]
["Number of bales grown",null,"ton"]
["How much could you sell that hay for?",{"$f":"B101","v":76},"per ton"]
[]
["Supplements"]
["Minerals/Salt description ","loose mineral, southern states watersed 2 to 1, "]
["Amount of minerals/salt purchased",52,"50 lb bag"]
["Price per unit",28,"per bag "]
[]
["Supplement 2 description","redman salt mineral, high selenium "]
["Amount of molasses purchased",40,"50 lb bags"]
["Price per unit",20]
[]
["Are there any additional supplements fed? "]
["If yes, cost of additional supplements"]
[]
["Animal health"]
["Describe your animal health and vaccination program. ","nothing for the sheep, vet help with the cattle, blackleg, 7 way shot, for calves, blackleg for cows too, maybe not every year, no dewormer, no fly control, might deworm the few bad looking cows they are getting ride of, deworms about 10% of sheep "]
["Do you have an established client relationship with a veterinarian who helps you with herd health?","yes, comes once a year "]
["Do you have a routine herd health program that includes annual vaccinations?","yes"]
["What diseases do you vaccinate for?","see above "]
[]
["Vaccine 1 description ","$800 for cattle vaccinations "]
["Which type of animal is it given too (cows, bull, calves) ",{"$f":"800/50","v":16}]
["Vaccine 1 units per animal "]
["Vaccine 1 cost per unit"]
["Number of animals administered "]
[]
["Vaccine 2 description "]
["Which type of animal is it given too (cows, bull, calves) "]
["Vaccine 2 units per animal "]
["Vaccine 2 cost per unit"]
["Number of animals administered "]
[]
["Vaccine 3 description "]
["Which type of animal is it given too (cows, bull, calves) "]
["Vaccine 3 units per animal "]
["Vaccine 3 cost per unit"]
["Number of animals administered "]
[]
["Vaccine 4 description "]
["Which type of animal is it given too (cows, bull, calves) "]
["Vaccine 4 units per animal "]
["Vaccine 4 cost per unit"]
["Number of animals administered "]
[]
[]
["Dewormer 1 description ","Cydectin- ","sheep- lavamsoyl"]
["Which type of animal is it given too (cows, bull, calves) ","less than 5 ","as little as zero and up too 200 with lambs, average is 50 lambs and a few ewes "]
["Dewormer 1 cost per unit",{"$f":"Assumptions!B70","v":0.81900000000000006},"per mL"]
["Dewormer 1 units per animal ",null,"ml"]
["Number of animals administered"]
[]
["Cost of emergency vet visits per year",150,"25 to 50 "]
[]
["ID description (ear tags)","eag tag"]
["Cost per unit","y tech with star on back "]
["Number of units purchased per year",50]
[]
["At what age are animals identified?","when born "]
[]
[]
["Fly control description","no fly control "]
["Fly control units","walk through $1000, more of a dairy use, cedar oil from fallen tree, 10 years "]
["Fly control price"]
[]
["Do you make any other medical/veterinary/ID purchases"]
["If yes, other medical cost estimate per year"]
[]
[]
[null,null,"months"]
["Are written or computer records kept for sick cattle, treatments, or death losses?","keep in phone some with notes"]
[]
["How often do you perform visual health checks of your herd?","daily "]
["Do you condition score your cow herd?","not written, doesn't want anything less than a 5 "]
[]
["Pasture"]
["How many acres is your farm? ",680,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["How many grazable acres for cattle?",200,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Do you rent any pasture? ","no ","Yes/No",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["If yes, what is rental rate per acre per year?",null,"per acre",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["If yes,  how many acres are rented",null,"acres",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["What is the current rental rate per acre for pasture of similar quality? ","$43 per acre","Is it per acre or per animal unit ",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Fertilizer",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Based on interview 1, you stated you applied the following fertilizers to your pastures. Can you please confirm and expand. ",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Fertilizer 1 description",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["How much fertilizer 1/year (lb./acre) ",null,"gal/acre",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Cost of fertilizer 1 ($/lb.) ",null,"per gal",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Acres applied",null,"acres",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Frequency (in years) ",null,"time per yer"]
[null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Fertilizer 2 description","Chicken litter","45 tons per year, 1.5 tons per ace",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["How much fertilizer 2/year (lb./acre) ",1.5,"tons/acre",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Cost of fertilizer 2 ($/lb.) ",40,"per ton ","someone else spread"]
["Acres applied",{"$f":"45/1.5","v":30},"acres"]
["Frequency (in years) ",1,"time per yer"]
[]
["Fertilizer 3 description","Lime"]
["How much fertilizer 3/year (lb./acre) ",1.5,"tons/acre"]
["Cost of fertilizer 3 ($/lb.) ",19,"per ton",950]
["Acres applied",33,"acres"]
["Frequency (in years) ",1,"time per yer","every 6 year"]
[]
["Herbicides/Pesticides"]
["Herb/Pest description","24D",null,"For fence lines, 24D and cross bow and some glyphosphate, 2.5 gallons each, google those prices"]
["How much acre/year (lb./acre) ",2.5,"gallons"]
["Cost of unit ($/lb.) ",25,"gallon "]
["Acres applied","fence lines"]
["Frequency (in years) ",1]
[]
["Herb/Pest description","crossbow"]
["How much acre/year (lb./acre) ",2.5,"gallons"]
["Cost of unit ($/lb.) ",23,"gallon"]
["Acres applied","fence lines"]
["Frequency (in years) ",1]
[]
[]
["Cover crops/seed"]
["Based on interview 1, you stated you used the following cover crops. Can you please confirm and expand. ","no till seeding, winter annual intercropping, rye grass ",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Cover crop type","spend about $1700 on winter and summer annuals, clover and other, up to around $3000",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Cost per unit",3000,"total","legumes, rye grass, annuals (cool season and summer) ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Units per acre"]
["Total acres ",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Other pasture cost",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Fence"]
["Permanent fence type","high tensile, average 5 strands, because of sheep","Ex. Barber wire, # strands, field fence",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Linear miles of permanent fence","5 miles of permiter fence and then cross fencing, 16 permanent field with 12 acreas, 2000*16, 11 miles total ",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[" price per foot installed ",{"$f":"Assumptions!#REF!","v":{"$error":"#REF!"}},"per foot",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Number of gates","32 gates ",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Cost per gate",40,"per gate",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Poly wire length ",{"$f":"1320*12","v":15840},"feet",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Poly wire cost per linear foot ",{"$f":"Assumptions!#REF!","v":{"$error":"#REF!"}},"per linear foot",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["# of Reels ",12,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Reel price",{"$f":"B244*1320","v":{"$error":"#REF!"}},"per reel",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["# of pushing posts",200,"posts",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Pushing post cost",3.5,"per post"]
["# of electrical chargers",3,"permanent chargers"]
["Cost per charger",700,"per charger"]
["How long does the temp fence materials last",15,"years"]
["Fencing repair percent year",0.1]
[]
["Water"]
["How do you get your animals water? ","well","monthly bill is $40 with 2 houses, $20 would for cattle, both cows and sheep, no ponds, "]
["Polypipe length",1.5,"miles"]
["Installation cost per foot",{"$f":"Assumptions!B86","v":1.1499999999999999}]
[]
["Water troughs ",6,null,"richey type, 25 gallons "]
["Portable water system","no "]
["Equipment"]
["Is all the equiptment for the cattle operation?"]
["Equipment 1 description ",{"$f":"F263","v":{"$error":"#REF!"}},"kabota, something 105S",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Age",20,"years",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Useful life (how long will it last?)",35,"years",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Original purchase price",0,"inhertied",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Salvage value at end of useful life (when you are done with it how much can you sell it for?)",null,null,"another 15 years",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Replacement cost (If you were to buy new today",null,null,"mostly for mowing and moving hay ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Equipment 2 description ","16' bush hog","woods, 20 years old ",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Age",20,"years",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Useful life"]
["Purchase price",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Salvage value at end of useful life",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Replacement cost"]
[]
["Equipment 3 description ","harrow","$300 to $400, 20 years old "]
["Age",20,"years"]
["Useful life"]
["Purchase price",350,"dollars","averaged 300 and 400"]
["Salvage value at end of useful life"]
["Replacement cost"]
[]
["Equipment 4 description",{"$f":"F266","v":{"$error":"#REF!"}},"flat bed trailer "]
["Age"]
["Useful life"]
["Purchase price",1500,"dollars"]
["Salvage value at end of useful life"]
["Replacement cost"]
[]
["Equipment 5 description ","16' stock trailer"]
["Age"]
["Useful life"]
["Purchase price",1000,"dollars"]
["Salvage value at end of useful life"]
["Replacement cost"]
[]
["Equipment 6 description ","ATV"]
["Age",10,"years"]
["Useful life",15,"years"]
["Purchase price",3000,"dollars"]
["Salvage value at end of useful life"]
["Replacement cost"]
[]
["Equipment 7 description ","herd seeder"]
["Age",20]
["Useful life"]
["Purchase price",200,"dollars"]
["Salvage value at end of useful life"]
["Replacement cost"]
[]
["Equipment 8 description ","2 small trailers"]
["Age"]
["Useful life"]
["Purchase price",1000,"a piece "]
["Salvage value at end of useful life"]
["Replacement cost"]
[]
["Pickup/Trucks","tayota tacoma, 2009, worth $5000 "]
["Age",10,"years"]
["Useful life"]
["Purchase price",5000]
["Salvage value at end of useful life"]
["Replacement cost"]
[]
["Pickup/Trucks","F250 farm truck, 2001, paid $14000 used in a few years ago "]
["Age",18,"years"]
["Useful life"]
["Purchase price",14000]
["Salvage value at end of useful life"]
["Replacement cost"]
[]
[]
["Equipment repair and upkeep costs estimate per year",1000,"4% of intital cost "]
[]
[]
[]
["Fuel "]
["Average gas purchased per week (gallons)",null,null,"2 times a year, 300 gallons, $750-$900 "]
["Average gas cost ($/gal)",45,"$/week ","gas: $70 week for everything- 50% cattle "]
["Average diesel purchased per week (gallons)",{"$f":"(2*300)/52 + (200/2.67/4)","v":30.265053298761167},"gallons","chester- $200 per month "]
["Average diesel cost ($/gal)",{"$f":"800/300","v":2.6666666666666665},"$/gal"]
[]
["Buildings/Structures/Facilities"]
["Building 1 description ","corral- squeeze chute, foremost, tub is WW rest is weldwire panels and boards",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Age",null,null,"old"]
["Useful life (how long will it last?)"]
["Original purchase price",2000]
["Replacement cost (If you were to buy new today"]
[]
["Building 2 description ","hay barn- been up for 20 years, 40X60  open on one end "]
["Age",20,"years"]
["Useful life (how long will it last?)"]
["Original purchase price"]
["Replacement cost (If you were to buy new today"]
[]
[]
["Primary Operator Labor","G","How much for cattle? "]
["Hours per week ",{"$f":"30*0.6","v":18},"hours per week ","fence is the most timely, maybe 50% or 40% less "]
["Work weeks per year",52,"week ","idaho state can increase prodution by 24% by adding sheep to cattle, 9% other way around "]
["Wage ($/hour) that could be earned if you worked somewhere else",45,"$/hour","lost 40 lambs "]
[]
["Family labor"]
["Number of family workers"]
["Hours per week "]
["Work weeks per year"]
["Wage ($/hour) or wage that could be earned if they worked somewhere else"]
[]
["Hired Labor","Chester"]
["Number of hired workers",1,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Hours per week ",32,"hrs/week",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Work weeks per year",52,"weeks"]
["Wage ($/hour)",14]
[]
["Do you train your employees on how to handle and care for your cattle?","no"]
["How do you train your employees?","knows to do low stress stuff, he is slow"]
["Do you attend beef producer educational events each year (extension programs, state organization meetings, etc.)? ","most for speaking, goes to grey judy, grass fed exchange "]
["if yes, how much do these education events cost? ",600]
[]
["Utilities"]
["Utility 1 description ","Electricty for running water"]
["Average monthly utility 1",40]
["Allocation to cow-calf",0.5]
[]
["Utility 2: description"]
["Average monthly utility 2"]
["Allocation to cow-calf",1]
[]
["Utility 3 description "]
["Average monthly utility 3"]
["Allocation to cow-calf",1]
[]
["Utility 4 description "]
["Average monthly utility 4"]
["Allocation to cow-calf",1]
[]
["Operating Loans"]
["Do you have an operating loan? ","Yes","Yes/No"]
["What is the going rate on operating loan interest",0.05]
[]
["Insurance"]
["Describe the type of insurance(s) in place for your operation"]
[]
["Insurance 1 description ","Liability insurance "]
["Amount of liability covered ","umbrella policy over $1000000"]
["Insurance 1 premium per year"]
["allocation to cattle operation "]
[]
["Insurance 2 description ","vehicle- not total coverage "]
["Insurance 2 premium per year"]
[]
[]
["Insurance 3 description "]
["Insurance 3 premium per year"]
[]
["Taxes"]
["Property tax",3400,"for all 600 acres"]
[]
["Federal income tax"]
["State income tax"]
["Social security "]
["Medicare ",null,"use standard rates"]
["Federal unemployment "]
["Other taxes major taxes (not sales tax)"]
[]
[]
["Are there any other major costs or revenues that are not included? If so, please describe. "]
["timber would be revenue stream but outside of pasture"]
[]
["$2.00 per pound, 70 lbs, 1.5X180 is number of lambs, ewe lambs sell for $220"]

{"sheet":"Directions","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Questions for Producers","index":2,"n_rows":561,"n_cols":5,"rows_kept":561,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["There are 11 broad categories of revenue and expenses we would like to understand about your enterprise: "]
["Note: Only include revenues and costs for cow-calf enterprise. If the cost or revenue is shared with another enterprise then change the allocation appropriately. "]
["Enterprise","Cow-Calf"]
["Dates","Oct 1 2017- Sept 30 2018"]
[]
["Breeding Herd",null,"Unit",null,"Notes"]
["Current breeding cows"]
["Number of breeding cows",null,"head"]
["Useful life of cow ",null,"years"]
["What percent of your cows have a calf that is sold or used as a replacement each year?"]
["What percent of your cows do you replace each year?"]
["How many cows die per year on your farm",null,"head"]
[]
["Replacement heifers/cows purchased"]
["Number of purchased replacement heifers/cows",null,"head"]
["Age of replacement heifers/cows at purchase",null,"months"]
["Weight of replacement heifers (lbs.) at purchase",null,"lbs"]
["Price per hundred-weight (cwt) of replacement heifers",null,"per cwt"]
[]
["Replacements heifers/cows retained from your herd"]
["Number of raised replacement heifers",null,"head"]
["If sold, at what age would you sell",null,"months"]
["If sold, anticipated weight at sale",null,"lbs"]
["Expected price per cwt of replacement heifers ",null,"per cwt"]
[]
["Breeding Bulls"]
["# of bulls on your cow-calf enterprise",null,"head"]
["On average, how much do you pay for a bull  ($/head)",null,"per head"]
["Useful life of bull (in years)",null,"years"]
["Salvage value for the bull, meaning when you are ready to sell the bull, what price do you expect to receive? ",null,"per head"]
[]
["Cost of Artificial Insemination (A.I.) per year",null,"per year"]
[]
["Market animals sold and marketing costs"]
["Feeder steers"]
["# of feeder steers sold",null,"head"]
["Average weight of feeder steer",null,"lbs"]
["Average age of feeder steers at sale",null,"months"]
["Average price per cwt for feeder steer ",null,"per cwt"]
[]
["Heifers"]
["# of feeder heifers sold",null,"head"]
["Average weight of feeder heifer",null,"lbs"]
["Average age of feeder heifer at sale",null,"months"]
["Average price per cwt for feeder heifer ",null,"per cwt"]
[]
["Bull Calves (Not Used on Herd)"]
["# of bull calves sold",null,"head"]
["Average weight of bull calf",null,"lbs"]
["Average age of bull calf at sale",null,"months"]
["Average price per cwt for bull calf",null,"per cwt"]
[]
["Cull Cows"]
["# of cull cows sold",null,"head"]
["Average weight of cull cow",null,"lbs"]
["Average price per cwt for cull cow ",null,"per cwt"]
[]
["Commission percent if sold at auction"]
["Total cost of transport to market",null,"annually"]
[]
["Beef check off assessment collected per head",null,"per head"]
[]
["Feed"]
["Purchased"]
["Purchased Feed 1 Description"]
["Units",null,null,"50 lb bag","Note: 50 lb bag/ton/bushel drop down"]
["Total units of feed purchased per year",null,{"$f":"IF(B66=\"\",\" \",CONCATENATE(B66,\"s\"))","v":" "},"ton"]
["Price per unit of feed",null,{"$f":"IF(B66=\"\",\" \",CONCATENATE(\"per \",B66))","v":" "},"bushel"]
[]
[]
[null,null,null,"F2"]
["Purchased Feed 2 description",null,null,"F2"]
["Units",null,null,"F2"]
["Total units of feed purchased per year",null,{"$f":"IF(B73=\"\",\" \",CONCATENATE(B73,\"s\"))","v":" "},"F2"]
["Price per unit of feed",null,{"$f":"IF(B73=\"\",\" \",CONCATENATE(\"per \",B73))","v":" "},"F2"]
[null,null,null,"F2"]
[null,null,null,"F2"]
[null,null,null,"F2"]
["Purchased Feed 3 description",null,null,"F3"]
["Units",null,null,"F3"]
["Total units of feed purchased per year",null,{"$f":"IF(B80=\"\",\" \",CONCATENATE(B80,\"s\"))","v":" "},"F3"]
["Price per unit of feed",null,{"$f":"IF(B80=\"\",\" \",CONCATENATE(\"per \",B80))","v":" "},"F3"]
[null,null,null,"F3"]
["Homegrown "]
["Homegrown Feed 1 description"]
["Units"]
["Total units of feed fed per year",null,{"$f":"IF(B86=\"\",\" \",CONCATENATE(B86,\"s\"))","v":" "}]
["Price per unit of feed if you were to sell to someone else",null,{"$f":"IF(B86=\"\",\" \",CONCATENATE(\"per \",B86))","v":" "}]
[]
[]
[null,null,null,"HF2"]
["Homegrown Feed 2 description",null,null,"HF2"]
["Units",null,null,"HF2"]
["Total units of feed fed per year",null,{"$f":"IF(B93=\"\",\" \",CONCATENATE(B93,\"s\"))","v":" "},"HF2"]
["Price per unit of feed if you were to sell to someone else",null,{"$f":"IF(B93=\"\",\" \",CONCATENATE(\"per \",B93))","v":" "},"HF2"]
[null,null,null,"HF2"]
[null,null,null,"HF2"]
[null,null,null,"HF3"]
["Homegrown Feed 3 description",null,null,"HF3"]
["Units",null,null,"HF3"]
["Total units of feed fed per year",null,{"$f":"IF(B100=\"\",\" \",CONCATENATE(B100,\"s\"))","v":" "},"HF3"]
["Price per unit of feed if you were to sell to someone else",null,{"$f":"IF(B100=\"\",\" \",CONCATENATE(\"per \",B100))","v":" "},"HF3"]
[]
["Hay"]
["Purchased"]
["Purchased Hay 1 description",null,null,"square bale"]
["Units for hay 1",null,null,"round bale","Note: square/round/1,000 lb bale drop down"]
["Number of units purchased",null,{"$f":"IF(B107=\"\",\" \",CONCATENATE(B107,\"s\"))","v":" "},"1,000 lb bale"]
["Price per unit",null,{"$f":"IF(B107=\"\",\" \",CONCATENATE(\"per \",B107))","v":" "}]
[]
[]
[null,null,null,"PH2"]
["Purchased Hay 2 description",null,null,"PH2"]
["Units for hay 2",null,null,"PH2"]
["Number of units purchased",null,{"$f":"IF(B114=\"\",\" \",CONCATENATE(B114,\"s\"))","v":" "},"PH2"]
["Price per unit",null,{"$f":"IF(B114=\"\",\" \",CONCATENATE(\"per \",B114))","v":" "},"PH2"]
[null,null,null,"PH2"]
["Homegrown"]
["Homegrown Hay 1 description"]
["Unit for hay"]
["Number of units grown",null,{"$f":"IF(B120=\"\",\" \",CONCATENATE(B120,\"s\"))","v":" "}]
["How much could you sell it for per unit",null,{"$f":"IF(B120=\"\",\" \",CONCATENATE(\"per \",B120))","v":" "}]
[]
[]
[null,null,null,"HH2"]
["Homegrown Hay 2 description",null,null,"HH2"]
["Unit for hay",null,null,"HH2"]
["Number of units grown",null,{"$f":"IF(B127=\"\",\" \",CONCATENATE(B127,\"s\"))","v":" "},"HH2"]
["How much could you sell it for per unit",null,{"$f":"IF(B127=\"\",\" \",CONCATENATE(\"per \",B127))","v":" "},"HH2"]
[]
["Supplements"]
["Supplement 1 description"]
["Units for supplement",null,null,null,"*Note: given the variety of supplements please fill in your units"]
["Amount of supplement purchased",null,{"$f":"IF(B133=\"\",\" \",CONCATENATE(B133,\"s\"))","v":" "}]
["Price per unit",null,{"$f":"IF(B133=\"\",\" \",CONCATENATE(\"per \",B133))","v":" "}]
[]
[]
[null,null,null,"S2"]
["Supplement 2 description",null,null,"S2","*Note: given the variety of supplements please fill in your units"]
["Units for supplement",null,null,"S2"]
["Amount of supplement purchased",null,{"$f":"IF(B140=\"\",\" \",CONCATENATE(B140,\"s\"))","v":" "},"S2"]
["Price per unit",null,{"$f":"IF(B140=\"\",\" \",CONCATENATE(\"per \",B140))","v":" "},"S2"]
[null,null,null,"S2"]
[null,null,null,"S2"]
[null,null,null,"S3"]
["Supplement 3 description",null,null,"S3","*Note: given the variety of supplements please fill in your units"]
["Units for supplement",null,null,"S3"]
["Amount of supplement purchased",null,{"$f":"IF(B147=\"\",\" \",CONCATENATE(B147,\"s\"))","v":" "},"S3"]
["Price per unit",null,{"$f":"IF(B147=\"\",\" \",CONCATENATE(\"per \",B147))","v":" "},"S3"]
[]
["If other feed/hay/supplements, enter total annual cost here",null,"per year"]
[]
["Animal health"]
["Vaccines",null,null,"calves"]
["Vaccine 1 description ",null,null,"cows"]
["Which type of animal is it given too",null,null,"bull(s)","Note: calves/cows/bull(s) drop down"]
["Vaccine 1 units",null,null,null,"Note: shot/mL drop down"]
["Vaccine 1 units administered per animal ",null,{"$f":"IF(B157=\"\",\" \",CONCATENATE(B157,\"s\"))","v":" "}]
["Vaccine 1 cost per unit",null,{"$f":"IF(B157=\"\",\" \",CONCATENATE(\"per \",B157))","v":" "},"shot"]
["Number of animals administered ",null,"head","mL"]
[]
[]
[null,null,null,"V2"]
["Vaccine 2 description ",null,null,"V2"]
["Which type of animal is it given too",null,null,"V2"]
["Vaccine 2 units",null,null,"V2"]
["Vaccine 2 units per animal ",null,{"$f":"IF(B166=\"\",\" \",CONCATENATE(B166,\"s\"))","v":" "},"V2"]
["Vaccine 2 cost per unit",null,{"$f":"IF(B166=\"\",\" \",CONCATENATE(\"per \",B166))","v":" "},"V2"]
["Number of animals administered ",null,"head","V2"]
[null,null,null,"V2"]
[null,null,null,"V2"]
[null,null,null,"V3"]
["Vaccine 3 description ",null,null,"V3"]
["Which type of animal is it given too (cows, bull, calves) ",null,null,"V3"]
["Vaccine 3 units",null,null,"V3"]
["Vaccine 3 units per animal ",null,{"$f":"IF(B175=\"\",\" \",CONCATENATE(B175,\"s\"))","v":" "},"V3"]
["Vaccine 3 cost per unit",null,{"$f":"IF(B175=\"\",\" \",CONCATENATE(\"per \",B175))","v":" "},"V3"]
["Number of animals administered ",null,"head","V3"]
[null,null,null,"V3"]
[null,null,null,"V3"]
[null,null,null,"V4"]
["Vaccine 4 description ",null,null,"V4"]
["Which type of animal is it given too",null,null,"V4"]
["Vaccine 4 units",null,null,"V4"]
["Vaccine 4 units per animal ",null,{"$f":"IF(B184=\"\",\" \",CONCATENATE(B184,\"s\"))","v":" "},"V4"]
["Vaccine 4 cost per unit",null,{"$f":"IF(B184=\"\",\" \",CONCATENATE(\"per \",B184))","v":" "},"V4"]
["Number of animals administered ",null,"head","V4"]
[null,null,null,"V4"]
["Dewormer"]
["Dewormer 1 description "]
["Which type of animal is it given too  "]
["Dewormer 1 units"]
["Dewormer 1 units per animal ",null,{"$f":"IF(B192=\"\",\" \",CONCATENATE(B192,\"s\"))","v":" "}]
["Dewormer 1 cost per unit",null,{"$f":"IF(B192=\"\",\" \",CONCATENATE(\"per \",B192))","v":" "}]
["Number of animals administered",null,"head"]
[]
[]
[null,null,null,"DW2"]
["Dewormer 2 description ",null,null,"DW2"]
["Which type of animal is it given too",null,null,"DW2"]
["Dewormer 2 units",null,null,"DW2"]
["Dewormer 2 units per animal ",null,{"$f":"IF(B201=\"\",\" \",CONCATENATE(B201,\"s\"))","v":" "},"DW2"]
["Dewormer 2 cost per unit",null,{"$f":"IF(B201=\"\",\" \",CONCATENATE(\"per \",B201))","v":" "},"DW2"]
["Number of animals administered",null,"head","DW2"]
[]
["Vet Visits"]
["Cost of planned vet visits per year",null,"per year"]
["Cost of emergency vet visits per year",null,"per year"]
[]
["ID description (ear tags)"]
["Cost per unit",null,"per unit"]
["Number of units purchased per year",null,"per year"]
[]
["Fly control costs per year including sprays, rubs, brushes, etc. "]
[]
["Other medical cost per year",null,"per year"]
[]
[]
["Pasture"]
["Acreage"]
["Total acres of your farm",null,"acres"]
["Acres dedicated to cow-calf enterprise",null,"acres"]
[]
["Acres rented for cow-calf enterprise",null,"acres"]
["Rental rate per acre per year",null,"per acre"]
[]
["Acres owned for cow-calf enterprise",null,"acres"]
["Although you own those acres, what is the current rental rate per acre for pasture of similar quality? ",null,"per acre"]
[]
["Fertilizer"]
["Fertilizer 1 description"]
["Fertilizer 1 units",null,null,null,"Note: gal/lb drop down"]
["Fertilizer 1 units per acre",null,{"$f":"IF(B232=\"\",\" \",CONCATENATE(B232,\"s\"))","v":" "},"gal"]
["Fertilizer 1 cost per unit",null,{"$f":"IF(B232=\"\",\" \",CONCATENATE(\"per \",B232))","v":" "},"lb"]
["Acres applied",null,"acres"]
["Frequency (in years) ",null,"times per year"]
[]
[]
[null,null,null,"F2"]
["Fertilizer 2 description",null,null,"F2"]
["Fertilizer 2 units",null,null,"F2"]
["Fertilizer 2 units per acre",null,{"$f":"IF(B241=\"\",\" \",CONCATENATE(B241,\"s\"))","v":" "},"F2"]
["Fertilizer 2 cost per unit",null,{"$f":"IF(B241=\"\",\" \",CONCATENATE(\"per \",B241))","v":" "},"F2"]
["Acres applied",null,"acres","F2"]
["Frequency (in years) ",null,"times per year","F2"]
[null,null,null,"F2"]
[null,null,null,"F2"]
[null,null,null,"F3"]
["Fertilizer 3 description",null,null,"F3"]
["Fertilizer 3 units",null,null,"F3"]
["Fertilizer 3 units per acre",null,{"$f":"IF(B250=\"\",\" \",CONCATENATE(B250,\"s\"))","v":" "},"F3"]
["Fertilizer 3 cost per unit",null,{"$f":"IF(B250=\"\",\" \",CONCATENATE(\"per \",B250))","v":" "},"F3"]
["Acres applied",null,"acres","F3"]
["Frequency (in years) ",null,"times per year","F3"]
[]
["Herbicides/Pesticides"]
["Herb/Pest 1 description"]
["Herb/Pest 1 units"]
["Herb/Pest 1 units per acre",null,{"$f":"IF(B258=\"\",\" \",CONCATENATE(B258,\"s\"))","v":" "}]
["Herb/Pest 1 cost per unit",null,{"$f":"IF(B258=\"\",\" \",CONCATENATE(\"per \",B258))","v":" "}]
["Acres applied",null,"acres"]
["Frequency (in years) ",null,"times per year"]
[]
[]
[null,null,null,"HP"]
["Herb/Pest 2 description",null,null,"HP"]
["Herb/Pest 2 units",null,null,"HP"]
["Herb/Pest 2 units per acre",null,{"$f":"IF(B267=\"\",\" \",CONCATENATE(B267,\"s\"))","v":" "},"HP"]
["Herb/Pest 2 cost per unit",null,{"$f":"IF(B267=\"\",\" \",CONCATENATE(\"per \",B267))","v":" "},"HP"]
["Acres applied",null,"acres","HP"]
["Frequency (in years) ",null,"times per year","HP"]
[]
["Cover Crops/Seed"]
["Cover crop 1 description"]
["Cover crop 1 unit"]
["Cover crop 1 units per acre",null,{"$f":"IF(B275=\"\",\" \",CONCATENATE(B275,\"s\"))","v":" "}]
["Cover crop 1 cost per unit",null,{"$f":"IF(B275=\"\",\" \",CONCATENATE(\"per \",B275))","v":" "}]
["Acres applied",null,"acres"]
[]
[]
[]
["Cover crop 2 description",null,null,"CC"]
["Cover crop 2 unit",null,null,"CC"]
["Cover crop 2 units per acre",null,{"$f":"IF(B283=\"\",\" \",CONCATENATE(B283,\"s\"))","v":" "},"CC"]
["Cover crop 2 cost per unit",null,{"$f":"IF(B283=\"\",\" \",CONCATENATE(\"per \",B283))","v":" "},"CC"]
["Acres applied",null,"acres","CC"]
[null,null,null,"CC"]
["Other pasture cost",null,"per year"]
[]
["Equipment and Buildings"]
["Buildings/Structures/Facilities",null,null,null,"*If the age is greater than useful life do not fill in purchase price or salvage value"]
["Buildings/Structures/Facilities 1 description "]
["Age",null,"years"]
["Useful life",null,"years"]
["Purchase price"]
["Salvage value at end of useful life"]
["Percent of use allocated to cow-calf enterprise"]
[]
[]
[null,null,null,"FA2"]
["Buildings/Structures/Facilities 2 description ",null,null,"FA2"]
["Age",null,"years","FA2"]
["Useful life",null,"years","FA2"]
["Purchase price",null,null,"FA2"]
["Salvage value at end of useful life",null,null,"FA2"]
["Percent of use allocated to cow-calf enterprise",null,null,"FA2"]
[null,null,null,"FA2"]
[null,null,null,"FA2"]
[null,null,null,"FA3"]
["Buildings/Structures/Facilities 3 description ",null,null,"FA3"]
["Age",null,"years","FA3"]
["Useful life",null,"years","FA3"]
["Purchase price",null,null,"FA3"]
["Salvage value at end of useful life",null,null,"FA3"]
["Percent of use allocated to cow-calf enterprise",null,null,"FA3"]
[]
["Buildings/Structures/Facilities repair and upkeep costs estimate per year",null,"per year"]
[]
["Fence"]
["Permanent Fence"]
["Type"]
["Linear miles",{"$f":"Fencing!C27","v":0},"miles"]
["Total installation cost "]
[]
["Gates"]
["Number of gates",null,"gates"]
["Cost per gate",null,"per gate"]
[]
["How long do the permanent fence materials last",null,"years"]
["Percent of permanent fence repaired each year",null,"per year"]
[]
["Temporary Fence"]
["Poly wire length ",null,"feet"]
["Poly wire cost per linear foot ",null,"per linear foot"]
["Number of Reels "]
["Cost per reel",null,"per reel"]
["Number of pushing posts",null,"posts"]
["Cost per pushing post",null,"per post"]
["Number of electrical chargers",null,"permanent chargers"]
["Cost per charger",null,"per charger"]
[]
["How long do the temporary fence materials last",null,"years"]
["Percent of temporary fence repaired each year",null,"per year"]
[]
["Water"]
["How do you get your animals water? "]
["Polypipe length",null,"miles"]
["Installation cost per foot",null,"per foot"]
["How long does the polypipe last",null,"years"]
["Percent of polypipe repaired each year",null,"per year"]
[]
["Number of water troughs "]
["Cost per water trough",null,"per water trough"]
["How long do water troughs last",null,"years"]
["Percent of watertroughs repaired each year",null,"per year"]
[]
["Do you have a portable water system",null,null,"Yes","Note: Yes/No drop down"]
["Cost of portable water system",null,null,"No"]
["How long does the portable water system last",null,"years"]
["Percent of portable water system repaired each year",null,"per year"]
[]
["Equipment"]
["Equipment 1 description "]
["Age",null,"years"]
["Useful life ",null,"years",null,"Note: How long will it last"]
["Original purchase price"]
["Salvage value at end of useful life ",null,null,null,"Note: When you are done with it how much can you sell it for"]
["Percent of use allocated to cow-calf enterprise"]
[]
[]
[null,null,null,"E2"]
["Equipment 2 description ",null,null,"E2"]
["Age",null,"years","E2"]
["Useful life ",null,"years","E2"]
["Original purchase price",null,null,"E2"]
["Salvage value at end of useful life ",null,null,"E2"]
["Percent of use allocated to cow-calf enterprise",null,null,"E2"]
[null,null,null,"E2"]
[null,null,null,"E2"]
[null,null,null,"E3"]
["Equipment 3 description ",null,null,"E3"]
["Age",null,"years","E3"]
["Useful life ",null,"years","E3"]
["Original purchase price",null,null,"E3"]
["Salvage value at end of useful life ",null,null,"E3"]
["Percent of use allocated to cow-calf enterprise",null,null,"E3"]
[null,null,null,"E3"]
[null,null,null,"E3"]
[null,null,null,"E4"]
["Equipment 4 description ",null,null,"E4"]
["Age",null,"years","E4"]
["Useful life ",null,"years","E4"]
["Original purchase price",null,null,"E4"]
["Salvage value at end of useful life ",null,null,"E4"]
["Percent of use allocated to cow-calf enterprise",null,null,"E4"]
[null,null,null,"E4"]
[null,null,null,"E4"]
[null,null,null,"E5"]
["Equipment 5 description ",null,null,"E5"]
["Age",null,"years","E5"]
["Useful life ",null,"years","E5"]
["Original purchase price",null,null,"E5"]
["Salvage value at end of useful life ",null,null,"E5"]
["Percent of use allocated to cow-calf enterprise",null,null,"E5"]
[null,null,null,"E5"]
[null,null,null,"E5"]
[null,null,null,"E6"]
["Equipment 6 description ",null,null,"E6"]
["Age",null,"years","E6"]
["Useful life ",null,"years","E6"]
["Original purchase price",null,null,"E6"]
["Salvage value at end of useful life ",null,null,"E6"]
["Percent of use allocated to cow-calf enterprise",null,null,"E6"]
[null,null,null,"E6"]
[null,null,null,"E6"]
[null,null,null,"E7"]
["Equipment 7 description ",null,null,"E7"]
["Age",null,"years","E7"]
["Useful life ",null,"years","E7"]
["Original purchase price",null,null,"E7"]
["Salvage value at end of useful life ",null,null,"E7"]
["Percent of use allocated to cow-calf enterprise",null,null,"E7"]
[null,null,null,"E7"]
[null,null,null,"E7"]
[null,null,null,"E8"]
["Equipment 8 description ",null,null,"E8"]
["Age",null,"years","E8"]
["Useful life ",null,"years","E8"]
["Original purchase price",null,null,"E8"]
["Salvage value at end of useful life ",null,null,"E8"]
["Percent of use allocated to cow-calf enterprise",null,null,"E8"]
[null,null,null,"E8"]
[null,null,null,"E8"]
[null,null,null,"E9"]
["Equipment 9 description ",null,null,"E9"]
["Age",null,"years","E9"]
["Useful life ",null,"years","E9"]
["Original purchase price",null,null,"E9"]
["Salvage value at end of useful life ",null,null,"E9"]
["Percent of use allocated to cow-calf enterprise",null,null,"E9"]
[]
["Pickup/Truck"]
["Pickup/Truck 1"]
["Age",null,"years"]
["Useful life ",null,"years"]
["Original purchase price"]
["Salvage value at end of useful life "]
["Percent of use allocated to cow-calf enterprise"]
[]
[]
[null,null,null,"PT"]
["Pickup/Truck 2",null,null,"PT"]
["Age",null,"years","PT"]
["Useful life ",null,"years","PT"]
["Original purchase price",null,null,"PT"]
["Salvage value at end of useful life ",null,null,"PT"]
["Percent of use allocated to cow-calf enterprise",null,null,"PT"]
[]
["Equipment repair and upkeep costs estimate per year"]
[]
["Fuel, Oild, and Utilities"]
["Fuel "]
["Average gas purchased per week",null,"gallons"]
["Average price of gas",null,"per gallon"]
["Average diesel purchased per week",null,"gallons"]
["Average price of diesel",null,"per gallon"]
[]
["Utilities"]
["Utility 1 Description"]
["Average monthly cost"]
["Allocation to cow-calf enterprise"]
[]
[]
[null,null,null,"Ut2"]
["Utility 2 Description",null,null,"Ut2"]
["Average monthly cost",null,null,"Ut2"]
["Allocation to cow-calf enterprise",null,null,"Ut2"]
[null,null,null,"Ut2"]
[null,null,null,"Ut2"]
[null,null,null,"Ut3"]
["Utility 3 Description",null,null,"Ut3"]
["Average monthly cost",null,null,"Ut3"]
["Allocation to cow-calf enterprise",null,null,"Ut3"]
[null,null,null,"Ut3"]
[null,null,null,"Ut3"]
[null,null,null,"Ut4"]
["Utility 4 Description",null,null,"Ut4"]
["Average monthly cost",null,null,"Ut4"]
["Allocation to cow-calf enterprise",null,null,"Ut4"]
[]
["Labor"]
["Primary Operator Labor"]
["Hours per week on cow-calf enterprise",null,"hours per week "]
["Work weeks per year",null,"weeks"]
["Value of operator labor",null,"per hour",null,"Note: wage could you earn working somewhere else"]
[]
["Family Labor"]
["Family member 1 name"]
["Hours per week ",null,"hours per week "]
["Work weeks per year",null,"weeks"]
["Wage",null,"per hour",null,"Note: if they are unpaid enter wage that could be earned if they worked somewhere else"]
[]
[]
[null,null,null,"Fam2"]
["Family member 2 name",null,null,"Fam2"]
["Hours per week ",null,"hours per week ","Fam2"]
["Work weeks per year",null,"weeks","Fam2"]
["Wage",null,"per hour","Fam2","Note: if they are unpaid enter wage that could be earned if they worked somewhere else"]
[]
["Hired Labor"]
["Hired labor 1 name"]
["Hours per week ",null,"hours per week "]
["Work weeks per year",null,"weeks"]
["Wage",null,"per hour"]
[]
[]
[null,null,null,"Hire2"]
["Hired labor 2 name",null,null,"Hire2"]
["Hours per week ",null,"hours per week ","Hire2"]
["Work weeks per year",null,"weeks","Hire2"]
["Wage",null,"per hour","Hire2"]
[]
["Costs for educational events, magazine subscriptions, conferences, etc.  "]
[]
["Operating Loans"]
["Do you have an operating loan? ",null,null,"Yes","Note: drop down for Yes/No"]
["Amount financed under your operating loan",null,null,"No"]
["Interest on operating loan"]
["Duration of operating loan",null,"months"]
[]
["Insurance"]
["Insurance 1 Description",null,null,null,"Note: Describe the type of insurance(s) in place for your cow-calf enterprise"]
["Amount of liability covered ",null,null,"monthly"]
["Premium",null,null,"semiannual","Note: drop down for frequency of payment"]
["Allocation to cow-calf enterprise",null,null,"annually"]
[]
[]
[null,null,null,"Ins2"]
["Insurance 2 Description",null,null,"Ins2"]
["Amount of liability covered ",null,null,"Ins2"]
["Premium",null,null,"Ins2"]
["Allocation to cow-calf enterprise",null,null,"Ins2"]
[null,null,null,"Ins2"]
[null,null,null,"Ins2"]
[null,null,null,"Ins3"]
["Insurance 3 Description",null,null,"Ins3"]
["Amount of liability covered ",null,null,"Ins3"]
["Premium",null,null,"Ins3"]
["Allocation to cow-calf enterprise",null,null,"Ins3"]
[]
["Taxes"]
["Total property tax"]
["Percent of property tax allocated to cow-calf enterprise"]
["Other taxes (not sales tax) associated with cow-calf enterprise"]
[]
["Other Revenues"]
["Revenue directly from cow-calf operation (semen, embryo, manure, etc.)",null,"per year"]
[]
["Other Costs"]
["Other Variable Costs",null,"per year"]
["Other Fixed Costs",null,"per year"]

{"sheet":"Fencing","index":3,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Assumptions:"]
[]
[null,null,null,null,null,null,null,"Fencing Type:","Installation Cost: $/ft","Economic Life: Years","Annual Replacement"]
[null,null,null,null,null,null,null,"Woven Wire",1.93,20,0.08]
[null,null,null,null,null,null,null,"Barbed Wire",1.48,20,0.08]
[null,null,null,null,null,null,null,"High-Tensile Non-Electric",1.24,25,0.05]
[null,null,null,null,null,null,null,"High-Tensile Electric",0.89,25,0.05]
[null,null,null,null,null,null,null,"Electrified Polywire",0.04,4,0.05]
[]
[]
[]
[]
[]
["Permanent Fence:"]
["Runs:","Fence Type:","Feet:","Installation Cost: $/ft","Miles:","Installation Cost: $/mi."]
["Run 1",null,null,null,{"$f":"C16/5280","v":0},{"$f":"D16*(5280)","v":0}]
["Run 2",null,null,null,{"$f":"C17/5280","v":0},{"$f":"D17*(5280)","v":0}]
["Run 3",null,null,null,0,0]
["Run 4",null,null,null,0,0]
["Run 5 ",null,null,null,0,0]
["Run 6",null,null,null,0,0]
["Run 7",null,null,null,0,0]
["Run 8",null,null,null,0,0]
["Run 9",null,null,null,0,0]
["Run 10",null,null,null,0,0]
[]
["Total Linear Miles of Permanent Fence:",null,{"$f":"SUM(E16:E25)","v":0}]
[]
["Total Installation Cost:",null,{"$f":"SUMPRODUCT(E16:E25,F16:F25)","v":0}]

{"sheet":"Enterprise budget","index":4,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Estimated returns and expenses for cow-calf operation "]
[]
["Revenue"]
[null,"Quantity","Units","Price","Units","$/cow","$/herd"]
[]
["Heifer calves",{"$f":"Marketing!B15","v":0},"lb.",{"$f":"Marketing!B17","v":0},"$/lb.",{"$f":"Marketing!B20","v":"0"},{"$f":"Marketing!B19","v":0}]
["Steer calves ",{"$f":"Marketing!B5","v":0},"lb.",{"$f":"Marketing!B7","v":0},"$/lb.",{"$f":"Marketing!B10","v":"0"},{"$f":"Marketing!B9","v":0}]
["Bull calves",{"$f":"Marketing!B27","v":0},"lb.",{"$f":"Marketing!B29","v":0},"$/lb.",{"$f":"Marketing!B32","v":"0"},{"$f":"Marketing!B31","v":0}]
["Cull cows",{"$f":"Marketing!B37","v":0},"lb.",{"$f":"Marketing!B39","v":0},"$/lb.",{"$f":"Marketing!B42","v":"0"},{"$f":"Marketing!B41","v":0}]
["Other Revnue",null,null,null,null,{"$f":"IF('Breeding Herd'!B4>0,G10/'Breeding Herd'!B4,\"0\")","v":"0"},{"$f":"'Questions for Producers'!B557","v":0}]
["Gross Income",null,null,null,null,{"$f":"SUM(F6:F10)","v":0},{"$f":"SUM(G6:G10)","v":0}]
[]
["Variable Costs",null,null,null,null,"$/cow","$/herd"]
["Bull charge/A.I. Costs",null,null,null,null,{"$f":"'Breeding Herd'!B45","v":"0"},{"$f":"'Breeding Herd'!B44","v":0}]
["Replacement females",null,null,null,null,{"$f":"'Breeding Herd'!B28","v":"0"},{"$f":"'Breeding Herd'!B27","v":0}]
["Marketing",null,null,null,null,{"$f":"Marketing!B53","v":"0"},{"$f":"Marketing!B52","v":0}]
["Feed",null,null,null,null,{"$f":"'Feed, Hay, Supplements'!B43","v":"0"},{"$f":"'Feed, Hay, Supplements'!B42","v":0}]
["Hay",null,null,null,null,{"$f":"'Feed, Hay, Supplements'!B73","v":"0"},{"$f":"'Feed, Hay, Supplements'!B72","v":0}]
["Mineral/supplements",null,null,null,null,{"$f":"'Feed, Hay, Supplements'!B96","v":"0"},{"$f":"'Feed, Hay, Supplements'!B95","v":0}]
["Veterinary, medicine, and identification ",null,null,null,null,{"$f":"'Animal Health'!B77","v":"0"},{"$f":"'Animal Health'!B76","v":0}]
["Pasture care",null,null,null,null,{"$f":"Pasture!B90","v":"0"},{"$f":"Pasture!B89","v":0}]
["Equipment and facility repairs",null,null,null,null,{"$f":"IF('Breeding Herd'!$B$4>0,'Equipment and Facilities'!B36+(('Equipment and Facilities'!B54+'Equipment and Facilities'!B74+'Equipment and Facilities'!B88+'Equipment and Facilities'!B97+'Equipment and Facilities'!B105)/'Breeding Herd'!B4)+'Equipment and Facilities'!B220,\"0\")","v":"0"},{"$f":"'Equipment and Facilities'!B219+'Equipment and Facilities'!B105+'Equipment and Facilities'!B97+'Equipment and Facilities'!B88+'Equipment and Facilities'!B74+'Equipment and Facilities'!B54+'Equipment and Facilities'!B35","v":0}]
[]
["Labor",null,null,null,null,{"$f":"Labor!B61","v":"0"},{"$f":"Labor!B60","v":0}]
["Education",null,null,null,null,{"$f":"Labor!B66","v":"0"},{"$f":"Labor!B65","v":0}]
["Fuel",null,null,null,null,{"$f":"'Fuel and Utilities'!B13","v":"0"},{"$f":"'Fuel and Utilities'!B12","v":0}]
["Utilities ",null,null,null,null,{"$f":"'Fuel and Utilities'!B37","v":"0"},{"$f":"'Fuel and Utilities'!B39","v":0}]
["Interest on operating capital ",null,null,null,null,{"$f":"'Operating Loan and Interest'!B11","v":"0"},{"$f":"'Fuel and Utilities'!B36","v":0}]
["Land Charge",null,null,null,null,{"$f":"Pasture!B14","v":"0"},{"$f":"Pasture!B13","v":0}]
["Other variable costs",null,null,null,null,{"$f":"IF('Breeding Herd'!$B$4>0,G30/'Breeding Herd'!B4,\"0\")","v":"0"},{"$f":"'Questions for Producers'!B560","v":0}]
["Total variable costs",null,null,null,null,{"$f":"SUM(F14:F30)","v":0},{"$f":"SUM(G14:G30)","v":0}]
[]
["Fixed Costs"]
["Equipment Depreciation ",null,null,null,null,{"$f":"'Equipment and Facilities'!B217+'Equipment and Facilities'!B194","v":0},{"$f":"'Equipment and Facilities'!B216+'Equipment and Facilities'!B193","v":0}]
["Facilitites Depreciation ",null,null,null,null,{"$f":"'Equipment and Facilities'!B108+'Equipment and Facilities'!B77+'Equipment and Facilities'!B57+'Equipment and Facilities'!B33","v":0},{"$f":"'Equipment and Facilities'!B32+'Equipment and Facilities'!B56+'Equipment and Facilities'!B76+'Equipment and Facilities'!B107","v":0}]
["Farm/livestock insurance",null,null,null,null,{"$f":"Insurance!B27","v":"0"},{"$f":"Insurance!B26","v":0}]
["Taxes",null,null,null,null,{"$f":"Taxes!B9","v":"0"},{"$f":"Taxes!B8","v":0}]
["Other fixed costs ",null,null,null,null,{"$f":"IF('Breeding Herd'!$B$4>0,G38/'Breeding Herd'!B4,\"0\")","v":"0"},{"$f":"'Questions for Producers'!B561","v":0}]
["Total fixed costs",null,null,null,null,{"$f":"SUM(F34:F38)","v":0},{"$f":"SUM(G34:G38)","v":0}]
[]
["Total costs",null,null,null,null,{"$f":"F39+F31","v":0},{"$f":"G39+G31","v":0}]
[]
["Income over variable costs",null,null,null,null,{"$f":"F11-F31","v":0},{"$f":"G11-G31","v":0}]
["Income over total costs ",null,null,null,null,{"$f":"F11-F41","v":0},{"$f":"G11-G41","v":0}]

{"sheet":"Breeding Herd","index":5,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,{"$f":"'Questions for Producers'!B4","v":"Oct 1 2017- Sept 30 2018"},null,null,null,"Coming from \"Questions from producers tab\" "]
[null,null,null,null,null,"Formula "]
["Cows"]
["Number of breeding cows",{"$f":"'Questions for Producers'!B8","v":0},{"$f":"'Questions for Producers'!C8","v":"head"}]
["Useful life of cow ",{"$f":"'Questions for Producers'!B9","v":0},{"$f":"'Questions for Producers'!C9","v":"years"}]
["Cow salvage value",{"$f":"Marketing!B40","v":0},"per head"]
["Weaning percentage",{"$f":"IF(B4>0,(Marketing!B4+Marketing!B14+'Breeding Herd'!B19)/'Breeding Herd'!B4,\"0\")","v":"0"}]
["Cow replacement percentage",{"$f":"IF(B4>0,(B11+B19)/'Breeding Herd'!B4,\"0\")","v":"0"}]
[]
["Replacement heifers"]
["Number of purchased replacement heifers",{"$f":"'Questions for Producers'!B15","v":0},{"$f":"'Questions for Producers'!C15","v":"head"}]
["Age of replacement heifers (years)",{"$f":"'Questions for Producers'!B16","v":0},{"$f":"'Questions for Producers'!C16","v":"months"}]
["Weight of replacement heifers (lbs.)",{"$f":"'Questions for Producers'!B17","v":0},{"$f":"'Questions for Producers'!C17","v":"lbs"}]
["Price per cwt of replacement heifers ",{"$f":"'Questions for Producers'!B18","v":0},{"$f":"'Questions for Producers'!C24","v":"per cwt"}]
["Replacement heifer price per head",{"$f":"(B13/100)*B14","v":0}]
["Total cost of replacement heifers",{"$f":"B15*B11","v":0}]
[]
["Raised replacement heifers"]
["Number of raised replacement heifers",{"$f":"'Questions for Producers'!B21","v":0},{"$f":"'Questions for Producers'!C21","v":"head"}]
["Age of replacement heifers in years",{"$f":"'Questions for Producers'!B22","v":0},{"$f":"'Questions for Producers'!C22","v":"months"}]
["Weight of replacement heifers (lbs.) if sol",{"$f":"'Questions for Producers'!B23","v":0},{"$f":"'Questions for Producers'!C23","v":"lbs"}]
["Expected price per cwt of replacement heifers ",{"$f":"'Questions for Producers'!B24","v":0},{"$f":"'Questions for Producers'!C24","v":"per cwt"}]
["Replacement heifer value per head",{"$f":"(B21/100)*B22","v":0}]
["Total value of replacement heifers",{"$f":"B23*B19","v":0}]
[]
["Implied replacement rate",{"$f":"IF(B4>0,(B11+B19)/B4,\"0\")","v":"0"}]
["TOTAL VALUE OF REPLACEMENT HEIFERS",{"$f":"B16+B24","v":0}]
["TOTAL VALUE OF REPLACEMENT HEIFERS PER COW",{"$f":"IF(B4>0,B27/$B$4,\"0\")","v":"0"}]
[]
["Bulls"]
["Number of bulls ",{"$f":"'Questions for Producers'!B27","v":0},{"$f":"'Questions for Producers'!C27","v":"head"}]
["Value of bull ($/head)",{"$f":"'Questions for Producers'!B28","v":0},{"$f":"'Questions for Producers'!C28","v":"per head"}]
["Total bull value",{"$f":"B32*B31","v":0}]
["Useful life of bull (in years)",{"$f":"'Questions for Producers'!B29","v":0},{"$f":"'Questions for Producers'!C29","v":"years"}]
["Salvage value of bull ",{"$f":"'Questions for Producers'!B30","v":0}]
["Total bull depreciation (or charge) per year",{"$f":"IF(B34>0,((B32-B35)/B34)*2,\"0\")","v":"0"}]
[]
["Average number of cows per bull ",{"$f":"IF(B31>0,B4/B31,\"0\")","v":"0"}]
["Percent of bull to charge per cow",{"$f":"IF(B31>0,1/B38,\"0\")","v":"0"}]
["Bull charge per cow per year",{"$f":"B36*B39","v":0}]
[]
[{"$f":"'Questions for Producers'!A32","v":"Cost of Artificial Insemination (A.I.) per year"},{"$f":"'Questions for Producers'!B32","v":0},{"$f":"'Questions for Producers'!C32","v":"per year"}]
[]
["TOTAL BULL AND A.I. COST",{"$f":"(B36*2)+B42","v":0}]
["Total bull and A.I. cost per cow",{"$f":"IF(B4>0,B44/B4,\"0\")","v":"0"}]
[]
["Depreciation "]
["Cow straight line per year",{"$f":"IF(B5>0,(B23-B6)/B5,\"0\")","v":"0"}]
["Bull straight line per year",{"$f":"IF(B34>0,(B32-B35)/B34,\"0\")","v":"0"}]

{"sheet":"Marketing","index":6,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,{"$f":"'Questions for Producers'!B4","v":"Oct 1 2017- Sept 30 2018"},null,null,null,"Coming from \"Questions from producers tab\" "]
[null,null,null,null,null,"Formula "]
["Steers"]
["Feeder steers sold",{"$f":"'Questions for Producers'!B36","v":0},{"$f":"'Questions for Producers'!C36","v":"head"}]
["Average weight of feeder steer",{"$f":"'Questions for Producers'!B37","v":0},{"$f":"'Questions for Producers'!C37","v":"lbs"}]
["Average price per cwt for feeder steer ",{"$f":"'Questions for Producers'!B39","v":0},{"$f":"'Questions for Producers'!C39","v":"per cwt"}]
["Average price per lb for feeder steer ",{"$f":"B6/100","v":0}]
["Implied feeder steer revenue per head",{"$f":"(B5/100)*B6","v":0}]
["Revenue from feeder steers",{"$f":"B8*B4","v":0}]
["Steer revenue per cow",{"$f":"IF('Breeding Herd'!B$4>0,B9/'Breeding Herd'!B$4,\"0\")","v":"0"}]
[{"$f":"'Questions for Producers'!A38","v":"Average age of feeder steers at sale"},{"$f":"'Questions for Producers'!B38","v":0},{"$f":"'Questions for Producers'!C38","v":"months"}]
[]
["Heifers"]
["Feeder heifers sold",{"$f":"'Questions for Producers'!B42","v":0},{"$f":"'Questions for Producers'!C42","v":"head"}]
["Average weight of feeder heifer",{"$f":"'Questions for Producers'!B43","v":0},{"$f":"'Questions for Producers'!C43","v":"lbs"}]
["Average price per cwt for feeder heifer ",{"$f":"'Questions for Producers'!B45","v":0},{"$f":"'Questions for Producers'!C45","v":"per cwt"}]
["Average price per lb for heifers",{"$f":"B16/100","v":0},"per lb"]
["Implied feeder heifer revenue per head",{"$f":"(B15/100)*B16","v":0}]
["Revenue from feeder heifers",{"$f":"B18*B14","v":0}]
["Heifer revenue per cow",{"$f":"IF('Breeding Herd'!B$4>0,B19/'Breeding Herd'!B$4,\"0\")","v":"0"}]
[{"$f":"'Questions for Producers'!A44","v":"Average age of feeder heifer at sale"},{"$f":"'Questions for Producers'!B44","v":0},{"$f":"'Questions for Producers'!C44","v":"months"}]
[]
["Implied weaning percentage",{"$f":"IF('Breeding Herd'!$B$4>0,(B4+B14)/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Bull Calves"]
["Bull calves sold",{"$f":"'Questions for Producers'!B48","v":0},{"$f":"'Questions for Producers'!C48","v":"head"}]
["Average weight of bull calf",{"$f":"'Questions for Producers'!B49","v":0},{"$f":"'Questions for Producers'!C49","v":"lbs"}]
["Average price per cwt for bull calf",{"$f":"'Questions for Producers'!B51","v":0},{"$f":"'Questions for Producers'!C51","v":"per cwt"}]
["Average price per lb for bull calf",{"$f":"B28/100","v":0}]
["Implied bull calf revenue per head",{"$f":"(B27/100)*B28","v":0}]
["Revenue from bull calves",{"$f":"B30*B26","v":0}]
["Bull revenue per cow",{"$f":"IF('Breeding Herd'!B$4>0,B31/'Breeding Herd'!B$4,\"0\")","v":"0"}]
["Average age of bull calf at sale",{"$f":"'Questions for Producers'!B50","v":0},{"$f":"'Questions for Producers'!C50","v":"months"}]
[]
["Cull Cows"]
["Cull cows sold",{"$f":"'Questions for Producers'!B54","v":0},{"$f":"'Questions for Producers'!C54","v":"head"}]
["Average weight of cull cow",{"$f":"'Questions for Producers'!B55","v":0},{"$f":"'Questions for Producers'!C55","v":"lbs"}]
["Average price per cwt for cull cow ",{"$f":"'Questions for Producers'!B56","v":0},{"$f":"'Questions for Producers'!C56","v":"per cwt"}]
["Average price per lb for cull cow ",{"$f":"B38/100","v":0}]
["Implied cull cow revenue per head",{"$f":"(B37/100)*B38","v":0}]
["Revenue from cull cows",{"$f":"B40*B36","v":0}]
["Cull cow revenue per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B41/'Breeding Herd'!B$4,\"0\")","v":"0"}]
["Implied cull cow percent",{"$f":"IF('Breeding Herd'!$B$4>0,B36/'Breeding Herd'!B4,\"0\")","v":"0"}]
[]
["Total gross revenue from animal sales",{"$f":"SUM(B9,B19,B41)","v":0}]
[]
["Marketing Costs"]
["Assumed market cost percent",{"$f":"'Questions for Producers'!B58","v":0}]
["Implied marketing costs",{"$f":"B48*B45","v":0}]
["Transport to market costs",{"$f":"'Questions for Producers'!B59","v":0},{"$f":"'Questions for Producers'!C59","v":"annually"}]
["Beef check off assessment paid",{"$f":"SUM(B4,B14,B36)*'Questions for Producers'!B61","v":0}]
["Total marketing costs",{"$f":"SUM(B49:B51)","v":0}]
["Marketing costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,(B52)/'Breeding Herd'!B$4,\"0\")","v":"0"}]

{"sheet":"Feed, Hay, Supplements","index":7,"n_rows":101,"n_cols":6,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,{"$f":"'Questions for Producers'!B4","v":"Oct 1 2017- Sept 30 2018"},null,null,null,"Coming from \"Questions from producers tab\" "]
[null,null,null,null,null,"Formula "]
["FEED"]
["Purchased Feed"]
[{"$f":"'Questions for Producers'!A65","v":"Purchased Feed 1 Description"},{"$f":"'Questions for Producers'!B65","v":0}]
["Amount of Feed purchased",{"$f":"'Questions for Producers'!B67","v":0},{"$f":"'Questions for Producers'!C67","v":" "}]
["Cost per unit of Feed",{"$f":"'Questions for Producers'!B68","v":0},{"$f":"'Questions for Producers'!C68","v":" "}]
["Feed 1 total cost",{"$f":"B6*B7","v":0}]
["Feed 1 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B8/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Feed 2 description",{"$f":"'Questions for Producers'!B72","v":0}]
["Amount of Feed purchased",{"$f":"'Questions for Producers'!B74","v":0},{"$f":"'Questions for Producers'!C74","v":" "}]
["Cost per unit of Feed",{"$f":"'Questions for Producers'!B75","v":0},{"$f":"'Questions for Producers'!C75","v":" "}]
["Feed 2 total cost",{"$f":"B12*B13","v":0}]
["Feed 2 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B14/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Feed 3 description",{"$f":"'Questions for Producers'!B79","v":0}]
["Amount of Feed purchased",{"$f":"'Questions for Producers'!B81","v":0},{"$f":"'Questions for Producers'!C81","v":" "}]
["Cost per unit of Feed",{"$f":"'Questions for Producers'!B82","v":0},{"$f":"'Questions for Producers'!C82","v":" "}]
["Feed 3 total cost",{"$f":"B18*B19","v":0}]
["Feed 3 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B20/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Homegrown Feed"]
["Homegrown Feed 1 description",{"$f":"'Questions for Producers'!B85","v":0}]
["Total units of feed fed per year",{"$f":"'Questions for Producers'!B87","v":0},{"$f":"'Questions for Producers'!C87","v":" "}]
["Value per unit of feed if you were to sell to someone else",{"$f":"'Questions for Producers'!B88","v":0},{"$f":"'Questions for Producers'!C88","v":" "}]
["Feed 1 total cost",{"$f":"B25*B26","v":0}]
["Feed 1 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B27/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Homegrown Feed 2 description",{"$f":"'Questions for Producers'!B92","v":0}]
["Total units of feed fed per year",{"$f":"'Questions for Producers'!B94","v":0},{"$f":"'Questions for Producers'!C94","v":" "}]
["Value per unit of feed if you were to sell to someone else",{"$f":"'Questions for Producers'!B95","v":0},{"$f":"'Questions for Producers'!C95","v":" "}]
["Feed 2 total cost",{"$f":"B31*B32","v":0}]
["Feed 2 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B33/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Homegrown Feed 3 description",{"$f":"'Questions for Producers'!B99","v":0}]
["Total units of feed fed per year",{"$f":"'Questions for Producers'!B94","v":0},{"$f":"'Questions for Producers'!C94","v":" "}]
["Value per unit of feed if you were to sell to someone else",{"$f":"'Questions for Producers'!B102","v":0},{"$f":"'Questions for Producers'!C102","v":" "}]
["Feed 3 total cost",{"$f":"B37*B38","v":0}]
["Feed 3 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B39/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["TOTAL FEED COSTS",{"$f":"SUM(B8,B14,B20,B27,B33,B39)","v":0}]
["Total feed costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B42/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["HAY"]
["Purchased Hay"]
["Hay 1 description",{"$f":"'Questions for Producers'!B106","v":0}]
["Number of units purchased",{"$f":"'Questions for Producers'!B108","v":0},{"$f":"'Questions for Producers'!C108","v":" "}]
["Price per unit",{"$f":"'Questions for Producers'!B109","v":0},{"$f":"'Questions for Producers'!C109","v":" "}]
["Hay 1 total cost",{"$f":"B48*B49","v":0}]
["Hay 1 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B50/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Hay 2 description",{"$f":"'Questions for Producers'!B113","v":0}]
["Number of units purchased",{"$f":"'Questions for Producers'!B115","v":0},{"$f":"'Questions for Producers'!C115","v":" "}]
["Price per unit",{"$f":"'Questions for Producers'!B116","v":0},{"$f":"'Questions for Producers'!C116","v":" "}]
["Hay 2 total cost",{"$f":"B54*B55","v":0}]
["Hay 2 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B56/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Homegrown Hay"]
["Hay 1 description",{"$f":"'Questions for Producers'!B119","v":0}]
["Number of units purchased",{"$f":"'Questions for Producers'!B121","v":0},{"$f":"'Questions for Producers'!C121","v":" "}]
["Price per unit",{"$f":"'Questions for Producers'!B122","v":0},{"$f":"'Questions for Producers'!C122","v":" "}]
["Hay 1 total cost",{"$f":"B61*B62","v":0}]
["Hay 1 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B63/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Hay 2 description",{"$f":"'Questions for Producers'!B126","v":0}]
["Number of units purchased",{"$f":"'Questions for Producers'!B128","v":0},{"$f":"'Questions for Producers'!C128","v":" "}]
["Price per unit",{"$f":"'Questions for Producers'!B129","v":0}]
["Hay 2 total cost",{"$f":"B67*B68","v":0}]
["Hay 2 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B69/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["TOTAL HAY COSTS",{"$f":"SUM(B69,B63,B56,B50)","v":0}]
["Total hay costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B72/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Supplements"]
["Supplement 1",{"$f":"'Questions for Producers'!B132","v":0}]
["Amount of supplement 1 purchased",{"$f":"'Questions for Producers'!B134","v":0},{"$f":"'Questions for Producers'!C134","v":" "}]
["Price per unit",{"$f":"'Questions for Producers'!B135","v":0},{"$f":"'Questions for Producers'!C135","v":" "}]
["Supplement 1 total cost",{"$f":"B77*B78","v":0}]
["Supplement 1 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B79/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Supplement 2",{"$f":"'Questions for Producers'!B139","v":0}]
["Amount of supplement 2 purchased",{"$f":"'Questions for Producers'!B141","v":0},{"$f":"'Questions for Producers'!C141","v":" "}]
["Price per unit",{"$f":"'Questions for Producers'!B142","v":0},{"$f":"'Questions for Producers'!C142","v":" "}]
["Supplement 2 total cost",{"$f":"B83*B84","v":0}]
["Supplement 2 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B85/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Supplement 3",{"$f":"'Questions for Producers'!B146","v":0}]
["Amount of supplement 3 purchased",{"$f":"'Questions for Producers'!B148","v":0},{"$f":"'Questions for Producers'!C148","v":" "}]
["Price per unit",{"$f":"'Questions for Producers'!B149","v":0},{"$f":"'Questions for Producers'!C149","v":" "}]
["Supplement 3 total cost",{"$f":"B89*B90","v":0}]
["Supplement 3 total cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B91/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
[]
["TOTAL SUPPLEMENT COSTS",{"$f":"SUM(B79,B85,B91)","v":0}]
["Total supplement costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B95/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Other feed costs",{"$f":"'Questions for Producers'!B151","v":0},"per year"]
[]
["TOTAL FEED COSTS",{"$f":"SUM(B42,B72,B95,B98)","v":0}]
["Total feed costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B100/'Breeding Herd'!$B$4,\"0\")","v":"0"}]

{"sheet":"Animal Health","index":8,"n_rows":77,"n_cols":6,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,{"$f":"'Questions for Producers'!B4","v":"Oct 1 2017- Sept 30 2018"},null,null,null,"Coming from \"Questions from producers tab\" "]
[null,null,null,null,null,"Formula "]
["Vaccination Regime"]
["Vaccine 1 description ",{"$f":"'Questions for Producers'!B155","v":0}]
["Which type of animal is it given too",{"$f":"'Questions for Producers'!B156","v":0}]
["Vaccine 1 units per animal ",{"$f":"'Questions for Producers'!B158","v":0},{"$f":"'Questions for Producers'!C158","v":" "}]
["Vaccine 1 cost per unit",{"$f":"'Questions for Producers'!B159","v":0},{"$f":"'Questions for Producers'!C159","v":" "}]
["Number of animals administered ",{"$f":"'Questions for Producers'!B160","v":0},{"$f":"'Questions for Producers'!C160","v":"head"}]
["Vaccine 1 total cost",{"$f":"B7*B6*B8","v":0}]
[]
["Vaccine 2 description ",{"$f":"'Questions for Producers'!B164","v":0}]
["Which type of animal is it given too",{"$f":"'Questions for Producers'!B165","v":0}]
["Vaccine 2 units per animal ",{"$f":"'Questions for Producers'!B167","v":0},{"$f":"'Questions for Producers'!C167","v":" "}]
["Vaccine 2 cost per unit",{"$f":"'Questions for Producers'!B168","v":0},{"$f":"'Questions for Producers'!C168","v":" "}]
["Number of animals administered ",{"$f":"'Questions for Producers'!B169","v":0},{"$f":"'Questions for Producers'!C169","v":"head"}]
["Vaccine 2 total cost",{"$f":"B14*B13*B15","v":0}]
[]
["Vaccine 3 description ",{"$f":"'Questions for Producers'!B173","v":0}]
["Which type of animal is it given too",{"$f":"'Questions for Producers'!B174","v":0}]
["Vaccine 3 units per animal ",{"$f":"'Questions for Producers'!B176","v":0},{"$f":"'Questions for Producers'!C176","v":" "}]
["Vaccine 3 cost per unit",{"$f":"'Questions for Producers'!B177","v":0},{"$f":"'Questions for Producers'!C177","v":" "}]
["Number of animals administered ",{"$f":"'Questions for Producers'!B178","v":0},{"$f":"'Questions for Producers'!C178","v":"head"}]
["Vaccine 3 total cost",{"$f":"B21*B20*B22","v":0}]
[]
["Vaccine 4 description ",{"$f":"'Questions for Producers'!B182","v":0}]
["Which type of animal is it given too",{"$f":"'Questions for Producers'!B183","v":0}]
["Vaccine 4 units per animal ",{"$f":"'Questions for Producers'!B185","v":0},{"$f":"'Questions for Producers'!C185","v":" "}]
["Vaccine 4 cost per unit",{"$f":"'Questions for Producers'!B186","v":0},{"$f":"'Questions for Producers'!C186","v":" "}]
["Number of animals administered ",{"$f":"'Questions for Producers'!B187","v":0},{"$f":"'Questions for Producers'!C187","v":"head"}]
["Vaccine 4 total cost",{"$f":"B28*B27*B29","v":0}]
[]
["TOTAL VACCINE COSTS",{"$f":"SUM(B30,B23,B16,B9)","v":0}]
["Total vaccine costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B32/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Deworming"]
["Dewormer 1 description ",{"$f":"'Questions for Producers'!B190","v":0}]
["Which type of animal is it given too",{"$f":"'Questions for Producers'!B191","v":0}]
["Dewormer 1 cost per unit",{"$f":"'Questions for Producers'!B193","v":0},{"$f":"'Questions for Producers'!C193","v":" "}]
["Dewormer 1 units per animal ",{"$f":"'Questions for Producers'!B194","v":0},{"$f":"'Questions for Producers'!C194","v":" "}]
["Number of animals administered",{"$f":"'Questions for Producers'!B195","v":0},{"$f":"'Questions for Producers'!C195","v":"head"}]
["Dewormer 1 total cost",{"$f":"B38*B39*B40","v":0}]
[]
["Dewormer 2 description ",{"$f":"'Questions for Producers'!B199","v":0}]
["Which type of animal is it given too",{"$f":"'Questions for Producers'!B200","v":0}]
["Dewormer 2 cost per unit",{"$f":"'Questions for Producers'!B202","v":0},{"$f":"'Questions for Producers'!C202","v":" "}]
["Dewormer 2 units per animal ",{"$f":"'Questions for Producers'!B203","v":0},{"$f":"'Questions for Producers'!C203","v":" "}]
["Number of animals administered",{"$f":"'Questions for Producers'!B204","v":0},{"$f":"'Questions for Producers'!C204","v":"head"}]
["Dewormer 2 total cost",{"$f":"B45*B46*B47","v":0}]
[]
["TOTAL DEWORMING COSTS",{"$f":"SUM(B48,B41)","v":0}]
["Total deworming costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B50/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Emergency vet visits "]
[{"$f":"'Questions for Producers'!A207","v":"Cost of planned vet visits per year"},{"$f":"'Questions for Producers'!B207","v":0},{"$f":"'Questions for Producers'!C207","v":"per year"}]
["Cost of emergency vet visits per year",{"$f":"'Questions for Producers'!B208","v":0},{"$f":"'Questions for Producers'!C208","v":"per year"}]
[]
["TOTAL VET COSTS",{"$f":"SUM(B54:B55)","v":0}]
["Total vet costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B57/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Identification costs"]
["ID description ",{"$f":"'Questions for Producers'!B210","v":0}]
["Cost per unit",{"$f":"'Questions for Producers'!B211","v":0},{"$f":"'Questions for Producers'!C211","v":"per unit"}]
["Number of units purchased ",{"$f":"'Questions for Producers'!B212","v":0},{"$f":"'Questions for Producers'!C212","v":"per year"}]
[]
["TOTAL ID COSTS",{"$f":"B62*B63","v":0}]
["Total ID costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B65/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Other animal health costs"]
["Fly control",{"$f":"'Questions for Producers'!B214","v":0}]
["Other medication cost estimate",{"$f":"'Questions for Producers'!B216","v":0}]
[]
["TOTAL OTHER ANIMAL HEALTH COSTS",{"$f":"SUM(B69:B70)","v":0}]
["Total other animal health costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B72/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
[]
["TOTAL MEDICAL AND ID COSTS",{"$f":"SUM(B72,B65,B55,B50,B32)","v":0}]
["Total medical and ID costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B76/'Breeding Herd'!$B$4,\"0\")","v":"0"}]

{"sheet":"Pasture","index":9,"n_rows":90,"n_cols":6,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,{"$f":"'Questions for Producers'!B4","v":"Oct 1 2017- Sept 30 2018"},null,null,null,"Coming from \"Questions from producers tab\" "]
[null,null,null,null,null,"Formula "]
["Acreage"]
[{"$f":"'Questions for Producers'!A221","v":"Total acres of your farm"},{"$f":"'Questions for Producers'!B221","v":0},{"$f":"'Questions for Producers'!C221","v":"acres"}]
[{"$f":"'Questions for Producers'!A222","v":"Acres dedicated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B222","v":0},{"$f":"'Questions for Producers'!C222","v":"acres"}]
[{"$f":"'Questions for Producers'!A224","v":"Acres rented for cow-calf enterprise"},{"$f":"'Questions for Producers'!B224","v":0},{"$f":"'Questions for Producers'!C224","v":"acres"}]
[{"$f":"'Questions for Producers'!A225","v":"Rental rate per acre per year"},{"$f":"'Questions for Producers'!B225","v":0},{"$f":"'Questions for Producers'!C225","v":"per acre"}]
[{"$f":"'Questions for Producers'!A227","v":"Acres owned for cow-calf enterprise"},{"$f":"'Questions for Producers'!B227","v":0},{"$f":"'Questions for Producers'!C227","v":"acres"}]
["Potential rental rate of owned acres",{"$f":"'Questions for Producers'!B228","v":0},{"$f":"'Questions for Producers'!C228","v":"per acre"}]
["Total acres per cow (stocking rate)",{"$f":"IF('Breeding Herd'!B4>0,B5/'Breeding Herd'!B4,\"0\")","v":"0"}]
["Total acres per breeding animal",{"$f":"IF('Breeding Herd'!B4>0,B5/('Breeding Herd'!B4+'Breeding Herd'!B31),\"0\")","v":"0"}]
[]
["TOTAL LAND COST",{"$f":"SUM((B6*B7),(B8*B9))","v":0}]
["Total land cost per cow",{"$f":"IF('Breeding Herd'!B4>0,B13/'Breeding Herd'!B4,\"0\")","v":"0"}]
[]
["Fertilizer"]
[{"$f":"'Questions for Producers'!A231","v":"Fertilizer 1 description"},{"$f":"'Questions for Producers'!B231","v":0}]
[{"$f":"'Questions for Producers'!A232","v":"Fertilizer 1 units"},{"$f":"'Questions for Producers'!B232","v":0}]
[{"$f":"'Questions for Producers'!A233","v":"Fertilizer 1 units per acre"},{"$f":"'Questions for Producers'!B233","v":0},{"$f":"'Questions for Producers'!C233","v":" "}]
[{"$f":"'Questions for Producers'!A234","v":"Fertilizer 1 cost per unit"},{"$f":"'Questions for Producers'!B234","v":0},{"$f":"'Questions for Producers'!C234","v":" "}]
[{"$f":"'Questions for Producers'!A235","v":"Acres applied"},{"$f":"'Questions for Producers'!B235","v":0},{"$f":"'Questions for Producers'!C235","v":"acres"}]
[{"$f":"'Questions for Producers'!A236","v":"Frequency (in years) "},{"$f":"'Questions for Producers'!B236","v":0},{"$f":"'Questions for Producers'!C236","v":"times per year"}]
["Cost per year",{"$f":"IF(B22>0,B21*B19*B20*(1/B22),\"0\")","v":"0"}]
[]
[{"$f":"'Questions for Producers'!A240","v":"Fertilizer 2 description"},{"$f":"'Questions for Producers'!B240","v":0}]
[{"$f":"'Questions for Producers'!A241","v":"Fertilizer 2 units"},{"$f":"'Questions for Producers'!B241","v":0}]
[{"$f":"'Questions for Producers'!A242","v":"Fertilizer 2 units per acre"},{"$f":"'Questions for Producers'!B242","v":0},{"$f":"'Questions for Producers'!C242","v":" "}]
[{"$f":"'Questions for Producers'!A243","v":"Fertilizer 2 cost per unit"},{"$f":"'Questions for Producers'!B243","v":0},{"$f":"'Questions for Producers'!C243","v":" "}]
[{"$f":"'Questions for Producers'!A244","v":"Acres applied"},{"$f":"'Questions for Producers'!B244","v":0},{"$f":"'Questions for Producers'!C244","v":"acres"}]
[{"$f":"'Questions for Producers'!A245","v":"Frequency (in years) "},{"$f":"'Questions for Producers'!B245","v":0},{"$f":"'Questions for Producers'!C245","v":"times per year"}]
["Cost per year",{"$f":"IF(B30>0,B29*B27*B28*(1/B30),\"0\")","v":"0"}]
[]
[{"$f":"'Questions for Producers'!A249","v":"Fertilizer 3 description"},{"$f":"'Questions for Producers'!B249","v":0}]
[{"$f":"'Questions for Producers'!A250","v":"Fertilizer 3 units"},{"$f":"'Questions for Producers'!B250","v":0}]
[{"$f":"'Questions for Producers'!A251","v":"Fertilizer 3 units per acre"},{"$f":"'Questions for Producers'!B251","v":0},{"$f":"'Questions for Producers'!C251","v":" "}]
[{"$f":"'Questions for Producers'!A252","v":"Fertilizer 3 cost per unit"},{"$f":"'Questions for Producers'!B252","v":0},{"$f":"'Questions for Producers'!C252","v":" "}]
[{"$f":"'Questions for Producers'!A253","v":"Acres applied"},{"$f":"'Questions for Producers'!B253","v":0},{"$f":"'Questions for Producers'!C253","v":"acres"}]
[{"$f":"'Questions for Producers'!A254","v":"Frequency (in years) "},{"$f":"'Questions for Producers'!B254","v":0},{"$f":"'Questions for Producers'!C254","v":"times per year"}]
["Cost per year",{"$f":"IF(B38>0,B37*B35*B36*(1/B38),\"0\")","v":"0"}]
[]
[]
["TOTAL FERTILIZER COST",{"$f":"SUM(B39,B31,B23)","v":0}]
["Total fertilizer cost per cow",{"$f":"IF('Breeding Herd'!B4>0,B42/'Breeding Herd'!B4,\"0\")","v":"0"}]
[]
[]
[{"$f":"'Questions for Producers'!A256","v":"Herbicides/Pesticides"}]
[{"$f":"'Questions for Producers'!A257","v":"Herb/Pest 1 description"},{"$f":"'Questions for Producers'!B257","v":0}]
[{"$f":"'Questions for Producers'!A258","v":"Herb/Pest 1 units"},{"$f":"'Questions for Producers'!B258","v":0}]
[{"$f":"'Questions for Producers'!A259","v":"Herb/Pest 1 units per acre"},{"$f":"'Questions for Producers'!B259","v":0},{"$f":"'Questions for Producers'!C259","v":" "}]
[{"$f":"'Questions for Producers'!A260","v":"Herb/Pest 1 cost per unit"},{"$f":"'Questions for Producers'!B260","v":0},{"$f":"'Questions for Producers'!C260","v":" "}]
[{"$f":"'Questions for Producers'!A261","v":"Acres applied"},{"$f":"'Questions for Producers'!B261","v":0},{"$f":"'Questions for Producers'!C261","v":"acres"}]
[{"$f":"'Questions for Producers'!A262","v":"Frequency (in years) "},{"$f":"'Questions for Producers'!B262","v":0},{"$f":"'Questions for Producers'!C262","v":"times per year"}]
["Cost per year",{"$f":"IF(B52>0,B49*B50*B51*(1/B52),\"0\")","v":"0"}]
[]
[{"$f":"'Questions for Producers'!A266","v":"Herb/Pest 2 description"},{"$f":"'Questions for Producers'!B266","v":0}]
[{"$f":"'Questions for Producers'!A267","v":"Herb/Pest 2 units"},{"$f":"'Questions for Producers'!B267","v":0}]
[{"$f":"'Questions for Producers'!A268","v":"Herb/Pest 2 units per acre"},{"$f":"'Questions for Producers'!B268","v":0},{"$f":"'Questions for Producers'!C268","v":" "}]
[{"$f":"'Questions for Producers'!A269","v":"Herb/Pest 2 cost per unit"},{"$f":"'Questions for Producers'!B269","v":0},{"$f":"'Questions for Producers'!C269","v":" "}]
[{"$f":"'Questions for Producers'!A270","v":"Acres applied"},{"$f":"'Questions for Producers'!B270","v":0},{"$f":"'Questions for Producers'!C270","v":"acres"}]
[{"$f":"'Questions for Producers'!A271","v":"Frequency (in years) "},{"$f":"'Questions for Producers'!B271","v":0},{"$f":"'Questions for Producers'!C271","v":"times per year"}]
["Cost per year",{"$f":"IF(B60>0,B57*B58*B59*(1/B60),\"0\")","v":"0"}]
[]
[]
["TOTAL HERBICIDE/PESTICIDE COST",{"$f":"B61+B53","v":0}]
["Total herbicide/pesticide cost per cow",{"$f":"IF('Breeding Herd'!B4>0,B64/'Breeding Herd'!B4,\"0\")","v":"0"}]
[]
[]
["Cover Crops/Seed"]
[{"$f":"'Questions for Producers'!A274","v":"Cover crop 1 description"},{"$f":"'Questions for Producers'!B274","v":0}]
[{"$f":"'Questions for Producers'!A275","v":"Cover crop 1 unit"},{"$f":"'Questions for Producers'!B275","v":0}]
[{"$f":"'Questions for Producers'!A276","v":"Cover crop 1 units per acre"},{"$f":"'Questions for Producers'!B276","v":0},{"$f":"'Questions for Producers'!C276","v":" "}]
[{"$f":"'Questions for Producers'!A277","v":"Cover crop 1 cost per unit"},{"$f":"'Questions for Producers'!B277","v":0},{"$f":"'Questions for Producers'!C277","v":" "}]
[{"$f":"'Questions for Producers'!A278","v":"Acres applied"},{"$f":"'Questions for Producers'!B278","v":0},{"$f":"'Questions for Producers'!C278","v":"acres"}]
["Cost per year",{"$f":"B73*B72*B71","v":0}]
[]
[{"$f":"'Questions for Producers'!A282","v":"Cover crop 2 description"},{"$f":"'Questions for Producers'!B282","v":0}]
[{"$f":"'Questions for Producers'!A283","v":"Cover crop 2 unit"},{"$f":"'Questions for Producers'!B283","v":0}]
[{"$f":"'Questions for Producers'!A284","v":"Cover crop 2 units per acre"},{"$f":"'Questions for Producers'!B284","v":0},{"$f":"'Questions for Producers'!C284","v":" "}]
[{"$f":"'Questions for Producers'!A285","v":"Cover crop 2 cost per unit"},{"$f":"'Questions for Producers'!B285","v":0},{"$f":"'Questions for Producers'!C285","v":" "}]
[{"$f":"'Questions for Producers'!A286","v":"Acres applied"},{"$f":"'Questions for Producers'!B286","v":0},{"$f":"'Questions for Producers'!C286","v":"acres"}]
["Cost per year",{"$f":"B78*B80*B79","v":0}]
[]
["TOTAL COVER CROP COST",{"$f":"SUM(B74,B81)","v":0}]
["Total cover crop cost per cow",{"$f":"IF('Breeding Herd'!B4>0,B83/'Breeding Herd'!B4,\"0\")","v":"0"}]
[]
[{"$f":"'Questions for Producers'!A288","v":"Other pasture cost"},{"$f":"'Questions for Producers'!B288","v":0}]
["Other pasture cost per cow",{"$f":"IF('Breeding Herd'!B4>0,B86/'Breeding Herd'!B4,\"0\")","v":"0"}]
[]
["TOTAL PASTURE CARE COST",{"$f":"B83+B42+B64+B86","v":0}]
["Total pasture care cost per cow",{"$f":"IF('Breeding Herd'!B4>0,B89/'Breeding Herd'!B4,\"0\")","v":"0"}]

{"sheet":"Labor","index":10,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,{"$f":"'Questions for Producers'!B4","v":"Oct 1 2017- Sept 30 2018"},null,null,null,"Coming from \"Questions from producers tab\" "]
[null,null,null,null,null,"Formula "]
[{"$f":"'Questions for Producers'!A492","v":"Primary Operator Labor"}]
[{"$f":"'Questions for Producers'!A493","v":"Hours per week on cow-calf enterprise"},{"$f":"'Questions for Producers'!B493","v":0},{"$f":"'Questions for Producers'!C493","v":"hours per week "}]
[{"$f":"'Questions for Producers'!A494","v":"Work weeks per year"},{"$f":"'Questions for Producers'!B494","v":0},{"$f":"'Questions for Producers'!C494","v":"weeks"}]
[{"$f":"'Questions for Producers'!A495","v":"Value of operator labor"},{"$f":"'Questions for Producers'!B495","v":0},{"$f":"'Questions for Producers'!C495","v":"per hour"}]
["Total hours per year",{"$f":"B4*B5","v":0}]
["Total operator labor hours per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B7/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
["Total primary operator costs",{"$f":"B6*B7","v":0}]
["Total primary operator labor costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B9/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
[{"$f":"'Questions for Producers'!A497","v":"Family Labor"}]
[{"$f":"'Questions for Producers'!A498","v":"Family member 1 name"},{"$f":"'Questions for Producers'!B498","v":0}]
[{"$f":"'Questions for Producers'!A499","v":"Hours per week "},{"$f":"'Questions for Producers'!B499","v":0},{"$f":"'Questions for Producers'!C499","v":"hours per week "}]
[{"$f":"'Questions for Producers'!A500","v":"Work weeks per year"},{"$f":"'Questions for Producers'!B500","v":0},{"$f":"'Questions for Producers'!C500","v":"weeks"}]
[{"$f":"'Questions for Producers'!A501","v":"Wage"},{"$f":"'Questions for Producers'!B501","v":0},{"$f":"'Questions for Producers'!C501","v":"per hour"}]
["Family member 1 labor hours per year",{"$f":"B14*B15","v":0}]
["Family member 1 labor hours per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B17/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
["Family member 1 labor costs",{"$f":"B16*B17","v":0}]
["Family member 1 labor costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B19/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
[{"$f":"'Questions for Producers'!A505","v":"Family member 2 name"},{"$f":"'Questions for Producers'!B505","v":0}]
[{"$f":"'Questions for Producers'!A506","v":"Hours per week "},{"$f":"'Questions for Producers'!B506","v":0},{"$f":"'Questions for Producers'!C506","v":"hours per week "}]
[{"$f":"'Questions for Producers'!A507","v":"Work weeks per year"},{"$f":"'Questions for Producers'!B507","v":0},{"$f":"'Questions for Producers'!C507","v":"weeks"}]
[{"$f":"'Questions for Producers'!A508","v":"Wage"},{"$f":"'Questions for Producers'!B508","v":0},{"$f":"'Questions for Producers'!C508","v":"per hour"}]
["Family member 2 labor hours per year",{"$f":"B23*B24","v":0}]
["Family member 2 labor hours per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B26/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
["Family member 2 labor costs",{"$f":"B25*B26","v":0}]
["Family member 2 labor costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B28/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Total family labor hours per year",{"$f":"B26+B17","v":0}]
["Total family labor hours per year per cow",{"$f":"B27+B18","v":0}]
["Total family labor costs",{"$f":"B28+B19","v":0}]
["Total family labor costs per cow",{"$f":"B29+B20","v":0}]
[]
[{"$f":"'Questions for Producers'!A510","v":"Hired Labor"}]
[{"$f":"'Questions for Producers'!A511","v":"Hired labor 1 name"},{"$f":"'Questions for Producers'!B511","v":0}]
[{"$f":"'Questions for Producers'!A512","v":"Hours per week "},{"$f":"'Questions for Producers'!B512","v":0},{"$f":"'Questions for Producers'!C512","v":"hours per week "}]
[{"$f":"'Questions for Producers'!A513","v":"Work weeks per year"},{"$f":"'Questions for Producers'!B513","v":0},{"$f":"'Questions for Producers'!C513","v":"weeks"}]
[{"$f":"'Questions for Producers'!A514","v":"Wage"},{"$f":"'Questions for Producers'!B514","v":0},{"$f":"'Questions for Producers'!C514","v":"per hour"}]
["Total hired labor 1 hours per year",{"$f":"B38*B39","v":0}]
["Total hired labor 1 hours per year per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B41/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
["Total hired labor 1 costs",{"$f":"B40*B41","v":0}]
["Total hired labor 1 costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B43/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
[{"$f":"'Questions for Producers'!A518","v":"Hired labor 2 name"},{"$f":"'Questions for Producers'!B518","v":0}]
[{"$f":"'Questions for Producers'!A519","v":"Hours per week "},{"$f":"'Questions for Producers'!B519","v":0},{"$f":"'Questions for Producers'!C519","v":"hours per week "}]
[{"$f":"'Questions for Producers'!A520","v":"Work weeks per year"},{"$f":"'Questions for Producers'!B520","v":0},{"$f":"'Questions for Producers'!C520","v":"weeks"}]
[{"$f":"'Questions for Producers'!A521","v":"Wage"},{"$f":"'Questions for Producers'!B521","v":0},{"$f":"'Questions for Producers'!C521","v":"per hour"}]
["Total hired labor 2 hours per year",{"$f":"B47*B48","v":0}]
["Total hired labor 2 hours per year per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B50/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
["Total hired labor 2 costs",{"$f":"B49*B50","v":0}]
["Total hired labor 2 costs per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B52/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Total hired labor hours per year",{"$f":"B50+B41","v":0}]
["Total hired labor hours per year per cow",{"$f":"B51+B42","v":0}]
["Total hired labor costs",{"$f":"B52+B43","v":0}]
["Total hired labor costs per cow",{"$f":"B53+B44","v":0}]
[]
["TOTAL LABOR EXPENSES",{"$f":"SUM(B9,B33,B57)","v":0}]
["Total labor and educational expenses per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B60/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
["Total labor hours per cow",{"$f":"SUM(B56,B32,B8)","v":0}]
[]
["Educational Expenses"]
[{"$f":"'Questions for Producers'!A523","v":"Costs for educational events, magazine subscriptions, conferences, etc.  "},{"$f":"'Questions for Producers'!B523","v":0}]
["Total educational expenses per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B65/'Breeding Herd'!$B$4,\"0\")","v":"0"}]

{"sheet":"Equipment and Facilities","index":11,"n_rows":220,"n_cols":6,"rows_kept":220,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,{"$f":"'Questions for Producers'!B4","v":"Oct 1 2017- Sept 30 2018"},null,null,null,"Coming from \"Questions from producers tab\" "]
[null,null,null,null,null,"Formula "]
[{"$f":"'Questions for Producers'!A291","v":"Buildings/Structures/Facilities"}]
[{"$f":"'Questions for Producers'!A292","v":"Buildings/Structures/Facilities 1 description "},{"$f":"'Questions for Producers'!B292","v":0}]
[{"$f":"'Questions for Producers'!A293","v":"Age"},{"$f":"'Questions for Producers'!B293","v":0},{"$f":"'Questions for Producers'!C293","v":"years"}]
[{"$f":"'Questions for Producers'!A294","v":"Useful life"},{"$f":"'Questions for Producers'!B294","v":0},{"$f":"'Questions for Producers'!C294","v":"years"}]
[{"$f":"'Questions for Producers'!A295","v":"Purchase price"},{"$f":"'Questions for Producers'!B295","v":0}]
[{"$f":"'Questions for Producers'!A296","v":"Salvage value at end of useful life"},{"$f":"'Questions for Producers'!B296","v":0}]
[{"$f":"'Questions for Producers'!A297","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B297","v":0}]
["Depreciation per year",{"$f":"IF(B6>0,(B7-B8)/B6,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf enterprise",{"$f":"B9*B10","v":0}]
[]
[{"$f":"'Questions for Producers'!A301","v":"Buildings/Structures/Facilities 2 description "},{"$f":"'Questions for Producers'!B301","v":0}]
[{"$f":"'Questions for Producers'!A302","v":"Age"},{"$f":"'Questions for Producers'!B302","v":0},{"$f":"'Questions for Producers'!C302","v":"years"}]
[{"$f":"'Questions for Producers'!A303","v":"Useful life"},{"$f":"'Questions for Producers'!B303","v":0},{"$f":"'Questions for Producers'!C303","v":"years"}]
[{"$f":"'Questions for Producers'!A304","v":"Purchase price"},{"$f":"'Questions for Producers'!B304","v":0}]
[{"$f":"'Questions for Producers'!A305","v":"Salvage value at end of useful life"},{"$f":"'Questions for Producers'!B305","v":0}]
[{"$f":"'Questions for Producers'!A306","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B306","v":0}]
["Depreciation per year",{"$f":"IF(B15>0,(B16-B17)/B15,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf enterprise",{"$f":"B19*B18","v":0}]
[]
[{"$f":"'Questions for Producers'!A310","v":"Buildings/Structures/Facilities 3 description "},{"$f":"'Questions for Producers'!B310","v":0}]
[{"$f":"'Questions for Producers'!A311","v":"Age"},{"$f":"'Questions for Producers'!B311","v":0},{"$f":"'Questions for Producers'!C311","v":"years"}]
[{"$f":"'Questions for Producers'!A312","v":"Useful life"},{"$f":"'Questions for Producers'!B312","v":0},{"$f":"'Questions for Producers'!C312","v":"years"}]
[{"$f":"'Questions for Producers'!A313","v":"Purchase price"},{"$f":"'Questions for Producers'!B313","v":0}]
[{"$f":"'Questions for Producers'!A314","v":"Salvage value at end of useful life"},{"$f":"'Questions for Producers'!B314","v":0}]
[{"$f":"'Questions for Producers'!A315","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B315","v":0}]
["Depreciation per year",{"$f":"IF(B24>0,(B25-B26)/B24,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf enterprise",{"$f":"B28*B27","v":0}]
[]
["Total facilities depreciation cost per year",{"$f":"B28+B19+B10","v":0}]
["TOTAL FACILITIES DEPRECIATION COST PER YEAR ALLOCATED TO COW-CALF ENTERPRISE",{"$f":"B11+B20+B29","v":0}]
["Total facilities depreciation allocated to cow-calf enterprise per year per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B32/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
[{"$f":"'Questions for Producers'!A317","v":"Buildings/Structures/Facilities repair and upkeep costs estimate per year"},{"$f":"'Questions for Producers'!B317","v":0}]
["Estimated facility repair costs per year per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B35/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Fence"]
["Permanent Fence"]
[{"$f":"'Questions for Producers'!A321","v":"Type"},{"$f":"'Questions for Producers'!B321","v":0}]
[{"$f":"'Questions for Producers'!A322","v":"Linear miles"},{"$f":"'Questions for Producers'!B322","v":0},{"$f":"'Questions for Producers'!C322","v":"miles"}]
[{"$f":"'Questions for Producers'!A323","v":"Total installation cost "},{"$f":"'Questions for Producers'!B323","v":0}]
[]
[{"$f":"'Questions for Producers'!A325","v":"Gates"}]
[{"$f":"'Questions for Producers'!A326","v":"Number of gates"},{"$f":"'Questions for Producers'!B326","v":0},{"$f":"'Questions for Producers'!C326","v":"gates"}]
[{"$f":"'Questions for Producers'!A327","v":"Cost per gate"},{"$f":"'Questions for Producers'!B327","v":0},{"$f":"'Questions for Producers'!C327","v":"per gate"}]
["Gate total cost",{"$f":"B45*B46","v":0}]
["TOTAL PERMANENT FENCE INVESTMENT",{"$f":"B47+B42","v":0}]
[]
[{"$f":"'Questions for Producers'!A329","v":"How long do the permanent fence materials last"},{"$f":"'Questions for Producers'!B329","v":0},{"$f":"'Questions for Producers'!C329","v":"years"}]
[{"$f":"'Questions for Producers'!A330","v":"Percent of permanent fence repaired each year"},{"$f":"'Questions for Producers'!B330","v":0},{"$f":"'Questions for Producers'!C330","v":"per year"}]
[]
["Depreciation of permanent fence per year",{"$f":"IF(B50>0,B48/B50,\"0\")","v":"0"}]
["Replacement cost of permanent fence per year",{"$f":"B48*B51","v":0}]
[]
["TOTAL PERMANENT FENCE ANNUAL COST",{"$f":"SUM(B53:B54)","v":0}]
["Total permanent fence annual cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B56/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
[{"$f":"'Questions for Producers'!A332","v":"Temporary Fence"}]
[{"$f":"'Questions for Producers'!A333","v":"Poly wire length "},{"$f":"'Questions for Producers'!B333","v":0},{"$f":"'Questions for Producers'!C333","v":"feet"}]
[{"$f":"'Questions for Producers'!A334","v":"Poly wire cost per linear foot "},{"$f":"'Questions for Producers'!B334","v":0},{"$f":"'Questions for Producers'!C334","v":"per linear foot"}]
[{"$f":"'Questions for Producers'!A335","v":"Number of Reels "},{"$f":"'Questions for Producers'!B335","v":0}]
[{"$f":"'Questions for Producers'!A336","v":"Cost per reel"},{"$f":"'Questions for Producers'!B336","v":0},{"$f":"'Questions for Producers'!C336","v":"per reel"}]
[{"$f":"'Questions for Producers'!A337","v":"Number of pushing posts"},{"$f":"'Questions for Producers'!B337","v":0},{"$f":"'Questions for Producers'!C337","v":"posts"}]
[{"$f":"'Questions for Producers'!A338","v":"Cost per pushing post"},{"$f":"'Questions for Producers'!B338","v":0},{"$f":"'Questions for Producers'!C338","v":"per post"}]
[{"$f":"'Questions for Producers'!A339","v":"Number of electrical chargers"},{"$f":"'Questions for Producers'!B339","v":0},{"$f":"'Questions for Producers'!C339","v":"permanent chargers"}]
[{"$f":"'Questions for Producers'!A340","v":"Cost per charger"},{"$f":"'Questions for Producers'!B340","v":0},{"$f":"'Questions for Producers'!C340","v":"per charger"}]
["TOTAL INVESTMENT IN TEMPORARY FENCE",{"$f":"(B60*B61)+(B62*B63)+(B64*B65)+(B66*B67)","v":0}]
[]
[{"$f":"'Questions for Producers'!A342","v":"How long do the temporary fence materials last"},{"$f":"'Questions for Producers'!B342","v":0},{"$f":"'Questions for Producers'!C342","v":"years"}]
[{"$f":"'Questions for Producers'!A343","v":"Percent of temporary fence repaired each year"},{"$f":"'Questions for Producers'!B343","v":0},{"$f":"'Questions for Producers'!C343","v":"per year"}]
[]
["Depreciation of temporary fence per year",{"$f":"IF(B70>0,B68/B70,\"0\")","v":"0"}]
["Replacement cost of temporary fence per year",{"$f":"B68*B71","v":0}]
[]
["TOTAL TEMPORARY FENCE ANNUAL COST",{"$f":"B73+B74","v":0}]
["Total temporary fence cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B76/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Water System"]
[{"$f":"'Questions for Producers'!A346","v":"How do you get your animals water? "},{"$f":"'Questions for Producers'!B346","v":0}]
[{"$f":"'Questions for Producers'!A347","v":"Polypipe length"},{"$f":"'Questions for Producers'!B347","v":0},{"$f":"'Questions for Producers'!C347","v":"miles"}]
[{"$f":"'Questions for Producers'!A348","v":"Installation cost per foot"},{"$f":"'Questions for Producers'!B348","v":0},{"$f":"'Questions for Producers'!C348","v":"per foot"}]
[{"$f":"'Questions for Producers'!A349","v":"How long does the polypipe last"},{"$f":"'Questions for Producers'!B349","v":0},{"$f":"'Questions for Producers'!C349","v":"years"}]
[{"$f":"'Questions for Producers'!A350","v":"Percent of polypipe repaired each year"},{"$f":"'Questions for Producers'!B350","v":0},{"$f":"'Questions for Producers'!C350","v":"per year"}]
["Cost of polypipe installation",{"$f":"B81*5820*B82","v":0}]
[]
["Depreciation of polypipe per year",{"$f":"IF(B83>0,B85/B83,\"0\")","v":"0"}]
["Replacement/repair cost of polypipe per year",{"$f":"B85*B84","v":0}]
[]
[{"$f":"'Questions for Producers'!A352","v":"Number of water troughs "},{"$f":"'Questions for Producers'!B352","v":0}]
[{"$f":"'Questions for Producers'!A353","v":"Cost per water trough"},{"$f":"'Questions for Producers'!B353","v":0},{"$f":"'Questions for Producers'!C353","v":"per water trough"}]
[{"$f":"'Questions for Producers'!A354","v":"How long do water troughs last"},{"$f":"'Questions for Producers'!B354","v":0},{"$f":"'Questions for Producers'!C354","v":"years"}]
[{"$f":"'Questions for Producers'!A355","v":"Percent of watertroughs repaired each year"},{"$f":"'Questions for Producers'!B355","v":0},{"$f":"'Questions for Producers'!C355","v":"per year"}]
["Cost of water troughs",{"$f":"B91*B90","v":0}]
[]
["Depreciation of water troughs per year",{"$f":"IF(B92>0,B94/B92,\"0\")","v":"0"}]
["Replacement/repair cost of water troughs per year",{"$f":"B94*B93","v":0}]
[]
[{"$f":"'Questions for Producers'!A357","v":"Do you have a portable water system"},{"$f":"'Questions for Producers'!B357","v":0}]
[{"$f":"'Questions for Producers'!A358","v":"Cost of portable water system"},{"$f":"'Questions for Producers'!B358","v":0}]
[{"$f":"'Questions for Producers'!A359","v":"How long does the portable water system last"},{"$f":"'Questions for Producers'!B359","v":0},{"$f":"'Questions for Producers'!C359","v":"years"}]
[{"$f":"'Questions for Producers'!A360","v":"Percent of portable water system repaired each year"},{"$f":"'Questions for Producers'!B360","v":0},{"$f":"'Questions for Producers'!C360","v":"per year"}]
[]
["Depreciation of portable water system per year",{"$f":"IF(B101>0,B100/B101,\"0\")","v":"0"}]
["Replacement/repair cost of portable water system per year",{"$f":"B102*B100","v":0}]
[]
["TOTAL WATER SYSTEM ANNUAL COST",{"$f":"B97+B96+B87+B88+B104+B105","v":0}]
["Total water system cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B107/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Equipment"]
[{"$f":"'Questions for Producers'!A363","v":"Equipment 1 description "},{"$f":"'Questions for Producers'!B363","v":0}]
[{"$f":"'Questions for Producers'!A364","v":"Age"},{"$f":"'Questions for Producers'!B364","v":0},{"$f":"'Questions for Producers'!C364","v":"years"}]
[{"$f":"'Questions for Producers'!A365","v":"Useful life "},{"$f":"'Questions for Producers'!B365","v":0},{"$f":"'Questions for Producers'!C365","v":"years"}]
[{"$f":"'Questions for Producers'!A366","v":"Original purchase price"},{"$f":"'Questions for Producers'!B366","v":0}]
[{"$f":"'Questions for Producers'!A367","v":"Salvage value at end of useful life "},{"$f":"'Questions for Producers'!B367","v":0}]
[{"$f":"'Questions for Producers'!A368","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B368","v":0}]
["Depreciation cost per year",{"$f":"IF(B113>0,(B114-B115)/B113,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf operation",{"$f":"B116*B117","v":0}]
[]
[{"$f":"'Questions for Producers'!A372","v":"Equipment 2 description "},{"$f":"'Questions for Producers'!B372","v":0}]
[{"$f":"'Questions for Producers'!A373","v":"Age"},{"$f":"'Questions for Producers'!B373","v":0},{"$f":"'Questions for Producers'!C373","v":"years"}]
[{"$f":"'Questions for Producers'!A374","v":"Useful life "},{"$f":"'Questions for Producers'!B374","v":0},{"$f":"'Questions for Producers'!C374","v":"years"}]
[{"$f":"'Questions for Producers'!A375","v":"Original purchase price"},{"$f":"'Questions for Producers'!B375","v":0}]
[{"$f":"'Questions for Producers'!A376","v":"Salvage value at end of useful life "},{"$f":"'Questions for Producers'!B376","v":0}]
[{"$f":"'Questions for Producers'!A377","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B377","v":0}]
["Depreciation per year",{"$f":"IF(B122>0,(B123-B124)/B122,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf operation",{"$f":"B125*B126","v":0}]
[]
[{"$f":"'Questions for Producers'!A381","v":"Equipment 3 description "},{"$f":"'Questions for Producers'!B381","v":0}]
[{"$f":"'Questions for Producers'!A382","v":"Age"},{"$f":"'Questions for Producers'!B382","v":0},{"$f":"'Questions for Producers'!C382","v":"years"}]
[{"$f":"'Questions for Producers'!A383","v":"Useful life "},{"$f":"'Questions for Producers'!B383","v":0},{"$f":"'Questions for Producers'!C383","v":"years"}]
[{"$f":"'Questions for Producers'!A384","v":"Original purchase price"},{"$f":"'Questions for Producers'!B384","v":0}]
[{"$f":"'Questions for Producers'!A385","v":"Salvage value at end of useful life "},{"$f":"'Questions for Producers'!B385","v":0}]
[{"$f":"'Questions for Producers'!A386","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B386","v":0}]
["Depreciation per year",{"$f":"IF(B131>0,(B132-B133)/B131,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf operation",{"$f":"B134*B135","v":0}]
[]
[{"$f":"'Questions for Producers'!A390","v":"Equipment 4 description "},{"$f":"'Questions for Producers'!B390","v":0}]
[{"$f":"'Questions for Producers'!A391","v":"Age"},{"$f":"'Questions for Producers'!B391","v":0},{"$f":"'Questions for Producers'!C391","v":"years"}]
[{"$f":"'Questions for Producers'!A392","v":"Useful life "},{"$f":"'Questions for Producers'!B392","v":0},{"$f":"'Questions for Producers'!C392","v":"years"}]
[{"$f":"'Questions for Producers'!A393","v":"Original purchase price"},{"$f":"'Questions for Producers'!B393","v":0}]
[{"$f":"'Questions for Producers'!A394","v":"Salvage value at end of useful life "},{"$f":"'Questions for Producers'!B394","v":0}]
[{"$f":"'Questions for Producers'!A395","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B395","v":0}]
["Depreciation per year",{"$f":"IF(B140>0,(B141-B142)/B140,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf operation",{"$f":"B143*B144","v":0}]
[]
[{"$f":"'Questions for Producers'!A399","v":"Equipment 5 description "},{"$f":"'Questions for Producers'!B399","v":0}]
[{"$f":"'Questions for Producers'!A400","v":"Age"},{"$f":"'Questions for Producers'!B400","v":0},{"$f":"'Questions for Producers'!C400","v":"years"}]
[{"$f":"'Questions for Producers'!A401","v":"Useful life "},{"$f":"'Questions for Producers'!B401","v":0},{"$f":"'Questions for Producers'!C401","v":"years"}]
[{"$f":"'Questions for Producers'!A402","v":"Original purchase price"},{"$f":"'Questions for Producers'!B402","v":0}]
[{"$f":"'Questions for Producers'!A403","v":"Salvage value at end of useful life "},{"$f":"'Questions for Producers'!B403","v":0}]
[{"$f":"'Questions for Producers'!A404","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B404","v":0}]
["Depreciation per year",{"$f":"IF(B149>0,(B150-B151)/B149,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf operation",{"$f":"B153*B152","v":0}]
[]
[{"$f":"'Questions for Producers'!A408","v":"Equipment 6 description "},{"$f":"'Questions for Producers'!B408","v":0}]
[{"$f":"'Questions for Producers'!A409","v":"Age"},{"$f":"'Questions for Producers'!B409","v":0},{"$f":"'Questions for Producers'!C409","v":"years"}]
[{"$f":"'Questions for Producers'!A410","v":"Useful life "},{"$f":"'Questions for Producers'!B410","v":0},{"$f":"'Questions for Producers'!C410","v":"years"}]
[{"$f":"'Questions for Producers'!A411","v":"Original purchase price"},{"$f":"'Questions for Producers'!B411","v":0}]
[{"$f":"'Questions for Producers'!A412","v":"Salvage value at end of useful life "},{"$f":"'Questions for Producers'!B412","v":0}]
[{"$f":"'Questions for Producers'!A413","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B413","v":0}]
["Depreciation per year",{"$f":"IF(B158>0,(B159-B160)/B158,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf operation",{"$f":"B161*B162","v":0}]
[]
[{"$f":"'Questions for Producers'!A417","v":"Equipment 7 description "},{"$f":"'Questions for Producers'!B417","v":0}]
[{"$f":"'Questions for Producers'!A418","v":"Age"},{"$f":"'Questions for Producers'!B418","v":0},{"$f":"'Questions for Producers'!C418","v":"years"}]
[{"$f":"'Questions for Producers'!A419","v":"Useful life "},{"$f":"'Questions for Producers'!B419","v":0},{"$f":"'Questions for Producers'!C419","v":"years"}]
[{"$f":"'Questions for Producers'!A420","v":"Original purchase price"},{"$f":"'Questions for Producers'!B420","v":0}]
[{"$f":"'Questions for Producers'!A421","v":"Salvage value at end of useful life "},{"$f":"'Questions for Producers'!B421","v":0}]
[{"$f":"'Questions for Producers'!A422","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B422","v":0}]
["Depreciation per year",{"$f":"IF(B167>0,(B168-B169)/B167,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf operation",{"$f":"B171*B170","v":0}]
[]
[{"$f":"'Questions for Producers'!A426","v":"Equipment 8 description "},{"$f":"'Questions for Producers'!B426","v":0}]
[{"$f":"'Questions for Producers'!A427","v":"Age"},{"$f":"'Questions for Producers'!B427","v":0},{"$f":"'Questions for Producers'!C427","v":"years"}]
[{"$f":"'Questions for Producers'!A428","v":"Useful life "},{"$f":"'Questions for Producers'!B428","v":0},{"$f":"'Questions for Producers'!C428","v":"years"}]
[{"$f":"'Questions for Producers'!A429","v":"Original purchase price"},{"$f":"'Questions for Producers'!B429","v":0}]
[{"$f":"'Questions for Producers'!A430","v":"Salvage value at end of useful life "},{"$f":"'Questions for Producers'!B430","v":0}]
[{"$f":"'Questions for Producers'!A431","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B431","v":0}]
["Depreciation per year",{"$f":"IF(B176>0,(B177-B178)/B176,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf operation",{"$f":"B179*B180","v":0}]
[]
[{"$f":"'Questions for Producers'!A435","v":"Equipment 9 description "},{"$f":"'Questions for Producers'!B435","v":0}]
[{"$f":"'Questions for Producers'!A436","v":"Age"},{"$f":"'Questions for Producers'!B436","v":0},{"$f":"'Questions for Producers'!C436","v":"years"}]
[{"$f":"'Questions for Producers'!A437","v":"Useful life "},{"$f":"'Questions for Producers'!B437","v":0},{"$f":"'Questions for Producers'!C437","v":"years"}]
[{"$f":"'Questions for Producers'!A438","v":"Original purchase price"},{"$f":"'Questions for Producers'!B438","v":0}]
[{"$f":"'Questions for Producers'!A439","v":"Salvage value at end of useful life "},{"$f":"'Questions for Producers'!B439","v":0}]
[{"$f":"'Questions for Producers'!A440","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B440","v":0}]
["Depreciation per year",{"$f":"IF(B185>0,(B186-B187)/B185,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf operation",{"$f":"B188*B189","v":0}]
[]
["Total equipment depreciation cost per year",{"$f":"B180+B171+B162+B153+B144+B135+B126+B117+B189","v":0}]
["TOTAL EQUIPMENT DEPRECIATION COST ALLOCATED TO COW-CALF OPERATION",{"$f":"B181+B172+B163+B154+B145+B136+B127+B118+B190","v":0}]
["Total equipment depreciation cost allocated to cow-calf operation per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B193/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["Pickup/Trucks"]
[{"$f":"'Questions for Producers'!A443","v":"Pickup/Truck 1"},{"$f":"'Questions for Producers'!B443","v":0}]
[{"$f":"'Questions for Producers'!A444","v":"Age"},{"$f":"'Questions for Producers'!B444","v":0},{"$f":"'Questions for Producers'!C444","v":"years"}]
[{"$f":"'Questions for Producers'!A445","v":"Useful life "},{"$f":"'Questions for Producers'!B445","v":0},{"$f":"'Questions for Producers'!C445","v":"years"}]
[{"$f":"'Questions for Producers'!A446","v":"Original purchase price"},{"$f":"'Questions for Producers'!B446","v":0}]
[{"$f":"'Questions for Producers'!A447","v":"Salvage value at end of useful life "},{"$f":"'Questions for Producers'!B447","v":0}]
[{"$f":"'Questions for Producers'!A448","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B448","v":0}]
["Depreciation per year",{"$f":"IF(B199>0,(B200-B201)/B199,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf operation",{"$f":"B203*B202","v":0}]
[]
[{"$f":"'Questions for Producers'!A452","v":"Pickup/Truck 2"},{"$f":"'Questions for Producers'!B452","v":0}]
[{"$f":"'Questions for Producers'!A453","v":"Age"},{"$f":"'Questions for Producers'!B453","v":0},{"$f":"'Questions for Producers'!C453","v":"years"}]
[{"$f":"'Questions for Producers'!A454","v":"Useful life "},{"$f":"'Questions for Producers'!B454","v":0},{"$f":"'Questions for Producers'!C454","v":"years"}]
[{"$f":"'Questions for Producers'!A455","v":"Original purchase price"},{"$f":"'Questions for Producers'!B455","v":0}]
[{"$f":"'Questions for Producers'!A456","v":"Salvage value at end of useful life "},{"$f":"'Questions for Producers'!B456","v":0}]
[{"$f":"'Questions for Producers'!A457","v":"Percent of use allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B457","v":0}]
["Depreciation per year",{"$f":"IF(B208>0,(B209-B210)/B208,\"0\")","v":"0"}]
["Depreciation cost per year allocated to cow-calf operation",{"$f":"B211*B212","v":0}]
[]
["Total pickup/truck depreciation cost per year",{"$f":"B212+B203","v":0}]
["TOTAL PICKUP/TRUCK DEPRECIATION COST ALLOCATED TO COW-CALF OPEARATION",{"$f":"B213+B204","v":0}]
["Total pickup/truck depreciation cost allocated to cow-calf operation per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B216/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
[{"$f":"'Questions for Producers'!A459","v":"Equipment repair and upkeep costs estimate per year"},{"$f":"'Questions for Producers'!B459","v":0}]
["Estimated equipment and truck repair costs per year per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B219/'Breeding Herd'!$B$4,\"0\")","v":"0"}]

{"sheet":"Fuel and Utilities","index":12,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,{"$f":"'Questions for Producers'!B4","v":"Oct 1 2017- Sept 30 2018"},null,null,null,"Coming from \"Questions from producers tab\" "]
[null,null,null,null,null,"Formula "]
[{"$f":"'Questions for Producers'!A462","v":"Fuel "}]
[{"$f":"'Questions for Producers'!A463","v":"Average gas purchased per week"},{"$f":"'Questions for Producers'!B463","v":0},{"$f":"'Questions for Producers'!C463","v":"gallons"}]
[{"$f":"'Questions for Producers'!A464","v":"Average price of gas"},{"$f":"'Questions for Producers'!B464","v":0},{"$f":"'Questions for Producers'!C464","v":"per gallon"}]
["Yearly gas costs",{"$f":"B5*B4*52","v":0}]
[]
[{"$f":"'Questions for Producers'!A465","v":"Average diesel purchased per week"},{"$f":"'Questions for Producers'!B465","v":0},{"$f":"'Questions for Producers'!C465","v":"gallons"}]
[{"$f":"'Questions for Producers'!A466","v":"Average price of diesel"},{"$f":"'Questions for Producers'!B466","v":0},{"$f":"'Questions for Producers'!C466","v":"per gallon"}]
["Yearly diesel costs",{"$f":"B9*B8*52","v":0}]
[]
["TOTAL FUEL COST",{"$f":"SUM(B6,B10)","v":0}]
["Total fuel cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B12/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
[{"$f":"'Questions for Producers'!A468","v":"Utilities"}]
[{"$f":"'Questions for Producers'!A469","v":"Utility 1 Description"},{"$f":"'Questions for Producers'!B469","v":0}]
[{"$f":"'Questions for Producers'!A470","v":"Average monthly cost"},{"$f":"'Questions for Producers'!B470","v":0}]
[{"$f":"'Questions for Producers'!A471","v":"Allocation to cow-calf enterprise"},{"$f":"'Questions for Producers'!B471","v":0}]
["Utility 1 cow-calf total",{"$f":"B17*B18*12","v":0}]
[]
[{"$f":"'Questions for Producers'!A475","v":"Utility 2 Description"},{"$f":"'Questions for Producers'!B475","v":0}]
[{"$f":"'Questions for Producers'!A476","v":"Average monthly cost"},{"$f":"'Questions for Producers'!B476","v":0}]
[{"$f":"'Questions for Producers'!A477","v":"Allocation to cow-calf enterprise"},{"$f":"'Questions for Producers'!B477","v":0}]
["Utility 2 cow-calf total",{"$f":"B22*B23*12","v":0}]
[]
[{"$f":"'Questions for Producers'!A481","v":"Utility 3 Description"},{"$f":"'Questions for Producers'!B481","v":0}]
[{"$f":"'Questions for Producers'!A482","v":"Average monthly cost"},{"$f":"'Questions for Producers'!B482","v":0}]
[{"$f":"'Questions for Producers'!A483","v":"Allocation to cow-calf enterprise"},{"$f":"'Questions for Producers'!B483","v":0}]
["Utility 3 cow-calf total",{"$f":"B27*B28*12","v":0}]
[]
[{"$f":"'Questions for Producers'!A487","v":"Utility 4 Description"},{"$f":"'Questions for Producers'!B487","v":0}]
[{"$f":"'Questions for Producers'!A488","v":"Average monthly cost"},{"$f":"'Questions for Producers'!B488","v":0}]
[{"$f":"'Questions for Producers'!A489","v":"Allocation to cow-calf enterprise"},{"$f":"'Questions for Producers'!B489","v":0}]
["Utility 4 cow-calf total",{"$f":"B32*B33*12","v":0}]
[]
["TOTAL UTILITY COSTS ALLOCATED TO COW-CALF ENTERPRISE",{"$f":"B34+B29+B24+B19","v":0}]
["Total utility costs allocated to cow-calf enterprise per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B36/'Breeding Herd'!$B$4,\"0\")","v":"0"}]
[]
["TOTAL FUEL AND UTILITIES",{"$f":"SUM(B36,B12)","v":0}]
["Total fuel and utilities per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B39/'Breeding Herd'!$B$4,\"0\")","v":"0"}]

{"sheet":"Operating Loan and Interest","index":13,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,{"$f":"'Questions for Producers'!B4","v":"Oct 1 2017- Sept 30 2018"},null,null,null,"Coming from \"Questions from producers tab\" "]
[null,null,null,null,null,"Formula "]
[{"$f":"'Questions for Producers'!A525","v":"Operating Loans"}]
[{"$f":"'Questions for Producers'!A526","v":"Do you have an operating loan? "},{"$f":"'Questions for Producers'!B526","v":0}]
[{"$f":"'Questions for Producers'!A527","v":"Amount financed under your operating loan"},{"$f":"'Questions for Producers'!B527","v":0}]
[{"$f":"'Questions for Producers'!A528","v":"Interest on operating loan"},{"$f":"'Questions for Producers'!B528","v":0}]
[{"$f":"'Questions for Producers'!A529","v":"Duration of operating loan"},{"$f":"'Questions for Producers'!B529","v":0},{"$f":"'Questions for Producers'!C529","v":"months"}]
["Total cost of interest",{"$f":"(B6/12)*B5*B7","v":0},null,null,"Note: simple interest is used"]
[]
["TOTAL OPERATING LOAN COST",{"$f":"B8","v":0}]
["Total operating loan cost per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B10/'Breeding Herd'!$B$4,\"0\")","v":"0"}]

{"sheet":"Taxes","index":14,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,{"$f":"'Questions for Producers'!B4","v":"Oct 1 2017- Sept 30 2018"},null,null,null,"Coming from \"Questions from producers tab\" "]
[null,null,null,null,null,"Formula "]
[{"$f":"'Questions for Producers'!A551","v":"Taxes"}]
[{"$f":"'Questions for Producers'!A552","v":"Total property tax"},{"$f":"'Questions for Producers'!B552","v":0}]
[{"$f":"'Questions for Producers'!A553","v":"Percent of property tax allocated to cow-calf enterprise"},{"$f":"'Questions for Producers'!B553","v":0}]
[{"$f":"'Questions for Producers'!A554","v":"Other taxes (not sales tax) associated with cow-calf enterprise"},{"$f":"'Questions for Producers'!B554","v":0}]
[]
["TOTAL TAXES PAID PER YEAR FOR COW-CALF OPERATION",{"$f":"(B4*B5)+B6","v":0}]
["Total taxes paid per year for cow-calf operation per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B8/'Breeding Herd'!$B$4,\"0\")","v":"0"}]

{"sheet":"Insurance","index":15,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,{"$f":"'Questions for Producers'!B4","v":"Oct 1 2017- Sept 30 2018"},null,null,null,"Coming from \"Questions from producers tab\" "]
[null,null,null,null,null,"Formula "]
[{"$f":"'Questions for Producers'!A531","v":"Insurance"}]
[{"$f":"'Questions for Producers'!A532","v":"Insurance 1 Description"},{"$f":"'Questions for Producers'!B532","v":0}]
[{"$f":"'Questions for Producers'!A533","v":"Amount of liability covered "},{"$f":"'Questions for Producers'!B533","v":0}]
[{"$f":"'Questions for Producers'!A534","v":"Premium"},{"$f":"'Questions for Producers'!B534","v":0},{"$f":"'Questions for Producers'!C534","v":0}]
[{"$f":"'Questions for Producers'!A535","v":"Allocation to cow-calf enterprise"},{"$f":"'Questions for Producers'!B535","v":0}]
["Number of payments",{"$f":"IF(C6=\"monthly\",12,(IF(C6=\"semiannual\",2,(IF(C6=\"annually\",1,0)))))","v":0}]
["Total annual cost for cow-calf enterprise",{"$f":"B8*B7*B6","v":0}]
[]
[{"$f":"'Questions for Producers'!A539","v":"Insurance 2 Description"},{"$f":"'Questions for Producers'!B539","v":0}]
[{"$f":"'Questions for Producers'!A540","v":"Amount of liability covered "},{"$f":"'Questions for Producers'!B540","v":0}]
[{"$f":"'Questions for Producers'!A541","v":"Premium"},{"$f":"'Questions for Producers'!B541","v":0},{"$f":"'Questions for Producers'!C541","v":0}]
[{"$f":"'Questions for Producers'!A542","v":"Allocation to cow-calf enterprise"},{"$f":"'Questions for Producers'!B542","v":0}]
["Number of payments",{"$f":"IF(C13=\"monthly\",12,(IF(C6=\"semiannual\",2,(IF(C6=\"annually\",1,0)))))","v":0}]
["Total annual cost for cow-calf enterprise",{"$f":"B13*B14*B15","v":0}]
[]
[{"$f":"'Questions for Producers'!A546","v":"Insurance 3 Description"},{"$f":"'Questions for Producers'!B546","v":0}]
[{"$f":"'Questions for Producers'!A547","v":"Amount of liability covered "},{"$f":"'Questions for Producers'!B547","v":0}]
[{"$f":"'Questions for Producers'!A548","v":"Premium"},{"$f":"'Questions for Producers'!B548","v":0},{"$f":"'Questions for Producers'!C548","v":0}]
[{"$f":"'Questions for Producers'!A549","v":"Allocation to cow-calf enterprise"},{"$f":"'Questions for Producers'!B549","v":0}]
["Number of payments",{"$f":"IF(C20=\"monthly\",12,(IF(C6=\"semiannual\",2,(IF(C6=\"annually\",1,0)))))","v":0}]
["Total annual cost for cow-calf enterprise",{"$f":"B20*B22*B21","v":0}]
[]
["Total insurance cost per year",{"$f":"(B6*B8)+(B13*B15)+(B20*B22)","v":0}]
["TOTAL INSURANCE COST ALLOCATED TO COW-CALF OPEARATION",{"$f":"B9+B16+B23","v":0}]
["Total insurance cost allocated to cow-calf operation per cow",{"$f":"IF('Breeding Herd'!$B$4>0,B26/'Breeding Herd'!B4,\"0\")","v":"0"}]

{"sheet":"Assumptions","index":16,"n_rows":92,"n_cols":9,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
["Assumed Prices","Price ","Unit","Source",null,null,"Assumed Economic/Useful Life","Years","Source"]
[]
["Land rental rate",35,"acre","AVG amp and non-amp",null,null,"Equipment"]
[null,null,null,null,null,null,"Machinery",10,"Iowa State Extension"]
["Animals",null,null,null,null,null,"Tractors",15,"Iowa State Extension"]
["Average price per cwt for feeder steer ",138.38999999999999,"per cwt","LMIC"]
["Average price per cwt for feeder heifer ",123.49,"per cwt","LMIC",null,null,"Buildings/Structures/Facilities"]
["Average price per cwt for cull cow ",53.2,"per cwt","LMIC",null,null,"Corral - squeeze chute",10,"Iowa State Extension"]
["Price per cwt of replacement heifers ",150,"per cwt","LMIC",null,null,"Fly control facility",10,"Iowa State Extension"]
["Expected price per cwt of replacement heifers ",150,"per cwt","LMIC",null,null,"Barn",20,"Rural Tax Education"]
["Assumed market cost percent",0.02]
["Value of bull ($/head)",6000,"per head"]
["Salvage value of bull ",1311.22,"per head"]
["Beef Check-Off ",1,"per head"]
[]
["Feed, Hay and Supplements "]
["Feed"]
["Corn ",3.4,"bu","USDA"]
["Range cubes",{"$f":"11.5/50","v":0.23},"lb","TSC"]
[]
["Hay"]
["Pasture grass hay ",104,"ton","USDA"]
["Alfalfa hay ",166.67,"ton","USDA"]
[]
["Supplements"]
["Protein Tub (200 lb)",69.989999999999995,"per tub","TSC"]
["Sulfur Salt (50 lb block)",8.2899999999999991,"per block","TSC"]
["Trace Mineral Salt (50 lb block)",6.49,"per block","Rural King"]
["Protein 24% Tub Sweetlix (200 lb)",80.11,"per tub","Feeds For Less"]
[]
["Fertilizers"]
["Nitrogen (lb.) ",0.17,"lb","Range Day"]
["Urea",0.44,"lb","dtnpf"]
["Phosphate",0.23,"lb","Range Day"]
["Potash (K-20)",0.16,"lb","Range Day"]
["Lime",12,"ton","MSU"]
["Chicken Litter",{"$f":"70.7/2000","v":3.5349999999999999E-2},"lb","Drovers"]
["Triple 19 ",{"$f":"57/25","v":2.2799999999999998},"lb","Amazon"]
["Fish Emulsion ",35,"gal","Amazon"]
["Sea-90 sea salt",{"$f":"35/50","v":0.7},"lb","seaagri.com"]
[]
[]
["Herbicides"]
["Crossbow",47.97,"gal","Rural King"]
["2,4 D",{"$f":"44.95/2.5","v":17.98},"gal","Keyston Pest Solutions"]
["Round Up Concentrate",{"$f":"77.67/85","v":0.91376470588235292},"gal made","Amazon"]
[]
[]
["Cover crops"]
["Winter Mix",{"$f":"16.99/1.5","v":11.326666666666666},"lb","Gardens Alive"]
["Rye",{"$f":"10.95/5","v":2.19},"lb","Hudson Valley Seed"]
["Red Clover",{"$f":"17.99/5","v":3.5979999999999999},"lb","Amazon"]
[]
["Vaccine prices "]
["Blackleg 7-way",{"$f":"45.79/50","v":0.91579999999999995},"ds","Valley Vet"]
["Cattlemaster 4 in 1",3.56,"ds","Valley Vet"]
["pink eye",{"$f":"44.29/50","v":0.88580000000000003},"ds","Valley Vet"]
["Tetnas Toxoid",{"$f":"21.99/10","v":2.1989999999999998},"ds","Valley Vet"]
[]
[]
["Identification prices"]
["y-tex tag",{"$f":"26.99/25","v":1.0795999999999999},"tag","Valley Vet"]
["EID tag",{"$f":"44.95/20","v":2.2475000000000001},"tag","Valley Vet"]
["z-tag",{"$f":"31.49/25","v":1.2595999999999998},"tag","Valley Vet"]
["Metal Cattle ID Ear Tag",{"$f":"19.99/100","v":0.19989999999999999},"tag","Valley Vet"]
[]
["Dewormer prices"]
["Cydectin Moxidectin",{"$f":"109/40","v":2.7250000000000001},"ds","Circle C Country Supply"]
["Eprizero Eprinomectin Pour-On for Beef & Dairy Cattle",0.09,"mL","Valley Vet"]
["Ivromec",{"$f":"40.95/50","v":0.81900000000000006},"mL","Valley Vet"]
["Ivermectin Pour On",{"$f":"20/250","v":0.08},"mL","TSC"]
[]
["Other medication "]
["LA200 ",{"$f":"24.99/100","v":0.24989999999999998},"mL","Valley Vet"]
[]
["Fly Control"]
["Martin's Permethrin Pour-On ",{"$f":"58.95/2.5","v":23.580000000000002},"gal","Valley Vet"]
["Pyranha Fly Space Spray",{"$f":"219.55/2.5","v":87.820000000000007},"gal","Valley Vet"]
[]
["Temporary Fence"]
["Price per reel",67.95,"per reel ","Valley Vet"]
["Pushing post cost",3.49,"per post","Valley Vet"]
["Charger cost",60,"per charger"]
[]
["Water"]
["Poly pipe cost",1.1499999999999999,"per foot"]
["115 gallon water trough",121.95,"per trough","Global Industrial"]
["700 gallon water trough",341.95,"per trough","Global Industrial"]
[]
["Farm Wages"]
["Labor ",10,"per hour","USDA"]
["Management ",20,"per hour","USDA"]